Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

MI1
7 - Meteor

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!

5 REPLIES 5
afv2688
16 - Nebula
16 - Nebula

Hello @MI1 ,

 

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

 

Untitled.png

 

Regards

MI1
7 - Meteor

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
16 - Nebula
16 - Nebula

Hello @MI1 ,

 

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

 

Regards

MI1
7 - Meteor

@afv2688 

 

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

 

MI1_0-1616430595573.png

MI1_2-1616430840260.png

 

pedrodrfaria
13 - Pulsar

@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.

 

pedrodrfaria_0-1616432568776.png

 

Labels