Batch remove null columns and output into multiple tabs

[kharabpati]

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! 

[jasperlch · Accepted solution]

Hi @kharabpati , 

The batch macro above should do the job. Please check the sample workflow + macro attached.

Jasper

[kharabpati]

Thanks @jasperich

This seems to work on my workflow as well! 

[MI1]

Hi  @jasperlch

I try to leverage the flow how can I change entity with an other fields name ?

Mederic