Remove Null Columns and output in multiple excel sheets/tabs during saving

[MI1]

Hi all, 

I am trying to output a table into multiple tabs after removing null columns. 

Example input:  

LBL Owner	Header 1	Header 2	Header 3	Header 4	Header 5	Header 6	Header 7	Header 8	Header 9	Header 10
A	Zxx	200		400	100	200		400
B	300		300			xsw		cww		ww
C				200
A	100	200		400	ww		ww	ww	www	ww
B	300		300		ww		dd
C				200			dd		dd

The output excel would have the three tabs with following different tables:

Tab A

LBL Owner	Header 1	Header 2	Header 4	Header 5	Header 6	Header 7	Header 8	Header 9	Header 10
A	zxx	200	400	100	200		400
A	100	200	400	ww		ww	ww	www	ww

Tab B

LBL Owner	Header 1	Header 3	Header 5	Header 6	Header 7	Header 8	Header 10
B	300	300		xsw		cww	ww
B	300	300	ww		dd

Tab C

LBL Owner	Header 4	Header 7	Header 9
C	200
C	200	dd	dd

I am currently using a saving each LBL Owner in an output tool that takes file name from the "LBL Onwer" column (multiple tabs same file) 

 Problem:

The output file does have 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!

[afv2688]

Hello @MI1 ,

On the output tool you are able to select on which column you want the data to be separated:

Regards

[MI1]

Hi @afv2688

thanks for the fast answer

The challenge is not to save in multiple tabs, the solutions offered is already in place :), or even with setting up the path name directly.

The main challenge which is to remove all empty columns in each tabs during the saving.

1- The main data is already without empty rows (50K rows) + 600 headers however 24 different tabs (can vary) 

2-  when I want to saved at a granular level, then I get some empty columns again as the 600 headers may not be in use in each tab.

I get a VBA code to loop each sheets and then delete each empty columns, however it take at least 15 min to run, checking if alteryx could help to format data directly.

[afv2688 · Accepted solution]

Hello @MI1 ,

Sorry for the misunderstanding. Think I got the right solution now 🙂

Regards

[MI1]

@afv2688 

Is that possible to save it with an older Alteryx version ? as I can not open the Flow 😞

[pedrodrfaria · Accepted solution]

@MI1 

Here are the files @afv2688  shared. 

Right click on them and open as a notepad, there you should be able to change the version to your version and then save it.