Select Columns that starts with a given Prefix in Power Query Dynamically
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.
