Hi
I have set-up a Tableau Prep flow to combine data I am using for timesheets. The data is stored in an individual excel sheet for each day of the year and I wanted to use the Union Multiple Tables functionality to combine each day to be able to created a dashboard.
However I keep getting the error message Incorrect request. Verify request payload and try again
not sure what I am doing wrong
Currently on builder version 22.21.22.0628.1001 (2022.2.1)
Given I will have 1 per day for 365 days I was trying to avoid creating manual links for each document. I will also be importing other data hence using prep rather than desktop that is not stored as part of the timesheet data
any help would be greatly appreciated
OK, what I did was triplicated the workbooks, so a total of three identical workbooks, located in the same folder. Then set the initial input (Tables) settings to be:
Workbook Wildcard = *.xlsx (so that it matches on all workbooks in the folder with that extension
Worksheet Wildcard = Individual Data (so that it excludes Individual Data (2) or other tabbed sheets in the same workbook )
Be sure to click Apply below the list of tables that it recognizes from the parameterized list. That resulted in an initial error because I had the primary worksheet still open - locking issue/error message - closing it then refreshing the flow caused that to go away, which got me to this view:
So, even if the tabs were named differently, you should still be able to use wildcard on the worksheet to be something like Individual Data (*) and that should pick up the additional sheets in that workbook if you were even doing that method.
If those settings continue not to work, then my only other thought is that its due to being structured as a Table within Excel instead of a simple range (no table structure) - but I don't think that should be the case... By any chance has this effort been tried with the version prior to most recent? Current version has unfortunately, a few bugs. Let us know what you get out of this? Best, Don
