Referencing the output tables for "Tables: Create table for each unique value" in subsequent steps

Veronika_208293

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?

Sarah_154708

Hi @Veronika_128563 ,

This step creates a table with three headers: Unique Value, Count, Table ID

My 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}} Excel