Deselect/remove column

[aparna0208]

Hi,

I'm trying to unselect/remove a column based on a condition. I have an email column where it could all be Empty or have values. If that column is empty it should be deselected. I tried this using dynamic select but for some reason I keep getting this error "unknown variable". Just wondering if I'm doing anything wrong or is there a better way to do this? Thank you in advance!

[aparna0208]

@Felipe_Ribeir0 I can use this if my output has that column but what if it's not then it would error out. Before the whole logic of applying data cleansing tool I worked on another logic. The input file I'm using in my workflow may or may not have email column so had to write a logic for that using text input and union tool and then a formula tool which checks if email is null or has a value and ignore that column based on the condition. After that is what I'm using data cleansing tool. If I have to use the filter tool as below then it won't work when there is no email column in the output.

[PanPP]

@aparna0208 

I believe you can create a flag column based on what values or output you are looking for and then filter out on that flag.

Hope this helps.

[Felipe_Ribeir0 · Accepted solution]

Hi @aparna0208 

You could union a text input with the column Email and without data just to allow the formula to work.

[aparna0208]

@Felipe_Ribeir0 Before seeing this solution I tried the same and it worked:) Thank you so much for all your inputs:)

[martinding]

Hi @aparna0208 

You could use a filter tool here, and prepare a list of common personal email providers as condition.

For example: