Removing columns based on condition in cells

Lauritsjust

Hi all

I am trying to remove multiple columns based on a number of conditions.
E.g. below.

I have the following cells:

I would like to remove all columns containing values such as ":20*" and "ABC" so that the final result will look like this:

As I do have 1000+ columns, I can not just use the select tool.

Do you have any suggestions to a solution so that i can delete multiple columns if they contains some specific string or even a specific number at the same time? 

Removingcolumnssupport.yxmd

atcodedog05

Hi @Lauritsjust 

You can use dynamic rename and dynamic select in combination like below to remove columns.

Workflow:

Hope this helps : )

Removingcolumnssupport.yxmd