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? 

[atcodedog05 · Accepted solution]

Hi @Lauritsjust 

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

Workflow:

Hope this helps : )

[Lauritsjust]

This is perfect, thanks alot for the quick response!

[atcodedog05]

Happy to help : ) @Lauritsjust 

Cheers and have a nice day!

[Lauritsjust]

@atcodedog2

While using the provided solution I found that some cells that contains either other words or empty/null cells are not removed.

Input:

I edited the filter tool to contain "and !Contains([Value], "-}")" but using and !Contains([Value], IsEmpty()) and and !Contains([Value], IsNull()) simply removes all data points. 

Current output:

Desired output: 

I edited the filter tool to contain "and !Contains([Value], "-}")" but using and !Contains([Value], IsEmpty()) and and !Contains([Value], IsNull()) simply removes all data points. 

Do you have a solution for this problem?

[Lauritsjust]

Sorry, multiple replies.

[atcodedog05 · Accepted solution]

Hi @Lauritsjust 

Please find the updated workflow.

Hope this helps : )

[Lauritsjust]

You are saving me hours of work, thank you again! 

[atcodedog05]

Happy to help : ) @Lauritsjust 

Cheers and have a nice day!