Alteryx Designer

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

Automatically Remove all null Colums

Highlighted
5 - Atom

Can you please provide an example file on how to combine these to tools to accomplish what is described in the image above? Is it possible to hide the columns without any data in them across many tabs?

Highlighted
5 - Atom

Were you able to to this across multiple tabs (that use grouping) to only generate columns with values?

Highlighted
Alteryx
Alteryx

@jlewis821 there is a workflow linked in my post under the accepted solution on page 1

Highlighted
5 - Atom

Will this work across tabs to only show columns that include data on each tab? I want each tab to show different date columns based in whether or not a transactions occurred on that date.  

Highlighted
Alteryx
Alteryx

@jlewis821  can you use the table option in this chat to draw out some sample data on the various tabs and your ideal outcome?

 

Best,

 

Jordan

Highlighted
6 - Meteoroid

Hi JordanB,

Do you think here is a way of packaging this up into a macro?

I want to apply it to an existing workflow that reads in a lot of Excel files and apply it to each one.

Thanks

 

Highlighted
5 - Atom

Hi @Federica_FF , I have tried using the autofield+dynamic select as you suggested but it didn't work. The thing is my all null column was not detected as boolean by the autofield tools. Any tips on how to solve this?

 

Thank you!

Highlighted
7 - Meteor

@123indo sometimes null fields end up registering as Double for me.  But if that doesn't work when you have other Double fields that you need to keep, then trying a different solution is probably best, such as @JordanB 's.

Labels