This video will show you how to filter column headers with conditions, and how we apply List.Select(), Table.ColumnNames(), Text.Contains(), Text.StartsWith(), Text.EndsWith() with examples.

Topic:
0:00 - Intro
0:45 - Filter Column Headers Explained
1:26 - Step 1 - Table.ColumnNames()
1:49 - Step 2 - List.Select() + Text.Contains()
2.32 - Step 3 - Apply Step 2 + Step 3 to Table.SelectColumns() / Table.RemoveColumns
2:58 - Update Keyword
3:20 - Text.EndsWith()
3:30 - Text.StartsWith()
3:36 - Bonus Example - Table.Unpivot
4:00 - Wrap up

Workbook:
[ Ссылка ]

свернуть