Select Columns that starts with a given Prefix in Power Query Dynamically

preview_player
Показать описание
In this Video, we shall see that how we can keep only Selected Columns from a Table that start with a given Prefix in Power Query (Dynamically).

Say we have the Columns - Name, Age, Region_1, Region_2, Region_3. We would see that how we can Select Columns that start with "Region_". So in future if a column "Region_4" gets added then our query will be dynamic. So selected columns will be Region_1, Region_2, Region_3, Region_4.
Рекомендации по теме
Комментарии
Автор

Excellent and in less than 2 minutes. Perfect!! Thanx.

jeromeastier
Автор

Bhavya Gupta can you explain the code with short description underneath the code in the video please.

qasimjan