New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

Dynamically remove columns that contain a specific word in the header in Power Query

It is very common when importing data from excel or pdfs that you get a lot of empty columns. In today’s video I will show you how to remove those columns dynamically using Power Query.

Table of contents:

00:00 Intro & case description
00:50 List all the column names in your table
01:11 Find the column names using List.FindText
01:50 Remove all columns that contains previous list with Table.RemoveColumns
02:30 Test the solution

Watch the tutorial:

Dynamically remove columns that contain a specific word in the header - Power Query
Was this helpful?
Previous Dynamically find and filter header rows and promote them in Power Query
Next Extract function in Power Query removes all the text? Here is how to fix it.

Reader Interactions

Let us know your thoughts...

Table of Contents