Curbal has its own social media server on Mastodon. Check it out here!

Curbal

Learn how to grow your business with your data and Power BI

You are here: Home / Knowledge Base / Dynamically remove columns that contain a specific word in the header in Power Query
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

< All Topics
Print

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

Posted
Updated
ByRuth Pozuelo Martinez

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?

Reader Interactions

Let us know your thoughts...

Table of Contents