This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi, I have been working on multiple workflows which each output two columns of data, the first column is always the month in the year (eg. 2018-01, 2018-02 etc.) and the second is the unique data tied to the workflow (specific indicator). The data in the second columns for each workflow is completely unrelated to each other so need to go down the route of joining based on the first column which I can get to work on a small scale (tested with 5 inputs and 'Join Multiple' tool) but will eventually be looking at 60+ indicators with unique data that will need to be joined and do not fancy the idea of having to add in 60+ 'Input' tools to a workflow.
Example of each individual 'indicator' output (from pre-run workflows);
Since you are creating the outputs, you can stream them all to one alteryx db with some id having to do with the workflow that it came from, i.e. a column called IndData#. This 3rd column will be constant for each output stream. All records from workflow 1 will have "Indicator 1 Data" in the IndData# column, workflow 2 will have "Indicator 2 Data", etc. In your final workflow, you read in the complete data for the db, and crosstab, grouping by the date, with new column headers being IndData# and values coming from [Indicator Data]
I have build a workflow with a batch macro which can help you.
The principle is to build a Batch macro doing a transposition of the data to keep the name of the field and to call the macro with the list of file to process, then to use a crosstab to put the field in column.
If it works for you don't hesitate to mark the solution as accepted.
Unfortunately, I was unable to view the batch macro suggested by WilliamR but was able to use the logic of the "Cross Tab" tool (I'm not too good with that tool!) suggested by danilang to build a simple workflow. I did not know what was meant by "stream them all to one alteryx db" so improvised using the CReW Macro "Wildcard XLSX Input" to union all the xlsx files from a target folder, which, with my test data, worked a treat! :)