initial work on filter-and-replicate sample

fgallop · fgallop · commit 9ae55832a592 · 2018-08-16T10:16:31.000-06:00
diff --git a/samples/filter-and-replicate/Job Time.twbx b/samples/filter-and-replicate/Job Time.twbx
diff --git a/samples/filter-and-replicate/databases.csv b/samples/filter-and-replicate/databases.csv
@@ -0,0 +1,4 @@
+Workbook,Format,Project,Branch
+Job Time,twbx,Operations - Edmonton,Edmonton
+Job Time,twbx,Operations - Abbotsford-Cor,Abbotsford-Cor
+Job Time,twbx,Operations - Abbotsford-Ref,Abbotsford-Ref
diff --git a/samples/filter-and-replicate/filter-and-replicate.py b/samples/filter-and-replicate/filter-and-replicate.py
@@ -0,0 +1,26 @@
+import csv              # so we can work with our database list (in a CSV file)
+
+############################################################
+# Step 1)  Use Workbook object from the Document API
+############################################################
+from tableaudocumentapi import Workbook
+
+############################################################
+# Step 3)  Use a database list (in CSV), loop thru and
+#          create new .twb's with their settings
+############################################################
+with open('databases.csv') as csvfile:
+    databases = csv.DictReader(csvfile, delimiter=',', quotechar='"')
+    for row in databases:
+
+        # Open the workbook
+        sourceWB = Workbook(row['Filename'] + row['Format'])
+
+        # Update the filters
+        for datasource in sourceWB.datasources:
+            for filter in datasource:
+                if filter.column == '[Branch]'
+                    filter.groupfilter.member = '&quot;' + row['Branch'] + '&quot;'
+                    
+        # Save our newly created workbook with the new file name
+        sourceWB.save_as(row['Filename'] + ' - ' + row['Branch'] + row['Format'])
