Referencing the output tables for "Tables: Create table for each unique value" in subsequent steps
Veronika_208293
Posts: 64
in Questions
I am using the "Tables: Create table for each unique value" action to separate a larger data table. Then in a subsequent step, I´d like to save each of these tables to an Excel, but I can´t find the right approach to reference the different output tables.
What would be the best way to go about this?
Tagged:
2
Best Answer
-
Hi @Veronika_128563 ,
This step creates a table with three headers:
Unique Value,Count,Table IDMy suggestion would be to use a Tables: Start Workflow for Each Row on this table.
In the sub-workflow, you should be able to use a Excel: Create a Spreadsheet from a Data Table action with
{{table-id}}.You then could make the output field name something dynamic to differentiate the excel file if you wish.
ie: {{unique-value}} Excel5
