Mass deleting columns, containing "value" if possible.

[PowerBO]

Hi there,

I have two workbooks that I need to merge, though each contains in excess of 400 columns. Perhaps fortunately, many of the redundant columns have a shared value/character in their heading. I'm hoping I can remove these columns quickly, based on said value. 

Does anyone know how to do that? 

Fingers crossed it's possible!

Thanks

[AlienSx · Accepted solution]

hi, @PowerBO try 

Table.RemoveColumns(Source, List.Select(Table.ColumnNames(Source), each Text.Contains(_, shared_value)))

[PowerBO]

Forgive me Aliensx, you've been kind enough to provide an answer, and i'm not smart enough to know how to implement it. 

I've altered the underscore after Text.Contains to reflect the value I want, but seemingly the Source values I enter are incorrect, thus I only see an error sadly. 

[AlienSx]

@PowerBO leave underscore alone (I hope our friend "underscore" forgives you 😉 , replace shared_value with something meaningful like "remove_me_please"