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
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:

Reader Interactions