Hi Everyone, I need some help on a workflow
Details:
1. The workflow will pull data from a table and then split containing different categories
2. The Dynamic input pulls in queried data that would contain a column 'Name' with these categories example A, B and C (there could over 100 categories) as rows and all the columns of the table queried
I am trying to create an output where I have an excel file that has in this example 3 excel tabs / sheets with only specific columns so,
1. Tab 1 should have data for A with columns 1-5
2. Tab 2 should have data for B with columns 1,3,5
3. Tab 3 should have data for C with columns 1,5,13 and so on for each row of data in column 'Name'
is there a way to accomplish this without using to many filter tools, currently the only thing that i can think of is separating each category manually, using a select tool and selecting specific columns and union them on position and then use the take file name from field in output however, that is to time consuming and I am hoping for a better way to complete this that is efficient
Solved! Go to Solution.
@olimpio This can be achieved with the help of the formula tool and output tool
1. Create a variable with your file path and name like below
2. configure your output data tool like below
Hi Binucas
thank you for your response.
just one thing is the output needs to have specific columns depending on the category
1. Tab 1 should have data for A with columns 1-5
2. Tab 2 should have data for B with columns 1,3,5
3. Tab 3 should have data for C with columns 1,5,13 and so on for each row of data in column 'Name'
is there a way to achieve that?
@olimpio One way of doing this is with the help of a batch macro. IF you want specific fields to be in specific tabs you need to mention the column names in a separate file