Hi Community, I have to delete columns, if they include specific values. E.g.: if Field 3 contains "Previous FC" and Field 6 contains "Previous Quarter", then these two columns should be deleted. Field 1Field 2Field 3Field 4Field 5 Field 6Field 7123872Previous FC9872000Previous Quarter387 Would be great if someone could help me. Thank you!

Conditional Delet Columns

Hi Community,

I have to delete columns, if they include specific values. E.g.:

if Field 3 contains "Previous FC" and Field 6 contains "Previous Quarter", then these two columns should be deleted.

Field 1	Field 2	Field 3	Field 4	Field 5	Field 6	Field 7
123	872	Previous FC	987	2000	Previous Quarter	387

Would be great if someone could help me.

Thank you!

Workflow

Accepted answers

afv2688

Hello @verast23 ,

How about this solution

Regards

select columns.yxmd

All comments

Emil_Kos

Hi @verast23,

I was thinking that I can sort it out with 2 formulas but it was a little bit more complicated.

First I have checked if the criteria are met. If yes I created a flag. Afterwards, I have used this flag to remove the data.

Remove.yxmd

messi007

@verast23,

Please see below:

Attached the workflow,

Hope this helps,

Regards

DeleteColuns_20210331.yxmd

verast23

Thanks @messi007 for your solution it works.

However, one more hurdle has occurred. In Field 3 & Field 6 is not always "Previous FC" & "Previous Quarter", so if Previous FC/Quarter isn't in Field 3/6, all columns should be shown.

If I remove Previous Quarter and Previous FC in your workflow, the filter tool gives me an error.

verast23

Hi @Emil_Kos ,

thanks for your solution. I still have the problem that the whole column was not deleted, although the criteria were met. I additionally got an warning message, that you are using a newer version of alteryx and that you possibly use tools that are not available for me.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703