Hi all,
I am trying to output a table into multiple tabs after removing null columns.
Example input:
Entity | Sub 0 | Sub 1 | Sub 2 | Sub 3 |
A | 100 | 200 | 400 | |
B | 300 | 300 | ||
C | 200 |
Te output excel would have the three tabs with following differenct tables:
Tab A
Entity | Sub 0 | Sub 1 | Sub 3 |
A | 100 | 200 | 400 |
Tab B
Entity | Sub 0 | Sub 2 |
B | 300 | 300 |
Tab C
Entity | Sub 3 |
C | 200 |
I am currently using a batch macro that filters the "Entity" and runs a crew macro that removes null columns. This then has an output tool that takes file name from the "Entity" column
Problem: The output file does have three different tabs, with just relevant rows, but it outputs all the columns, including the empty ones. I have searched everywhere to try and resolve this issue, I really hope you guys will be able to help!
Solved! Go to Solution.
Hi @kharabpati ,
The batch macro above should do the job. Please check the sample workflow + macro attached.
Jasper
Thanks @jasperich
This seems to work on my workflow as well!
Hi @jasperlch
I try to leverage the flow how can I change entity with an other fields name ?
Mederic