Deselect/remove column

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

Deselect remove column.yxmd

All comments

martinding

It is because the Email field needs to be wrapped around by brackets. [Email]

@martinding Thank you for the response. I already tried that and it didn't work.

binu_acs

@aparna0208 have you tried the data cleansing tool - the remove null columns option selected

The only way of doing this with the dynamic select tool that i know is by passing the columns that you want to select to a dynamic select tool that is inside a macro. But the easiest way is using the data cleansing tool.

You can find a example of how to do it using both methods on the attached file.

Deselect remove column.yxzp

@martinding @Felipe_Ribeir0 @binu_acs Ah I don't know how did I forget this simple data cleansing tool that did the magic. Thank you so much for all your inputs and reminding me about this tool:) It worked:)

Having said this I need help with one last thing. Now that I'm using data cleansing tool to remove the email field if it's all null and keep it if it has values. I have one more step where I have to see if that email column exists in the output then need to apply a filter to remove all personal emails. Is there a way to do this to see if that column exists in the output and if so apply this logic if not ignore? @martinding @Felipe_Ribeir0 @binu_acs

I believe that you can filter out the fields that contain "@gmail.com", "@yahoo.com" etc

or filter in the fields that contain "@company1.com", "@company2.com". I would take the second way.

Before of the data cleansing tool, ofc.

Deselect remove column.yxmd

PanPP

You can use a filter or a formula tool depending on what you are trying to do.

In the filter tool, you can filter by contains @gmail.com, @mail.com etc

In the formula tool, you can do If Contains([ColumnName], "@gmal.com") then "Remove" else "Keep" endif... etc

Something like this would help you accomplish that.

Hope this helps.

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

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

Deselect remove column.yxmd

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

martinding