Filter out columns based on name of column

[naveennandigam]

Hi All,

I have a workflow which reads Excel file with multiple tabs and joins the columns. Columns on each tab are mostly different. There are few columns with headers like Misc, Misc 1, Misc #2 etc.I would like to  filter out. Could anyone please tell me how I could do that?

[alexnajm · Accepted solution]

Dynamic Select is your best bet! Using a formula like !Contains([Name], ‘Misc’) should work

[naveennandigam]

Dynamic Select tool has worked, just changed the formula to !StartsWith([Name], 'Misc') and it is not case sensitive