Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I need to keep the first and last columns of multiple sheets I'm pulling in from Excel.
They vary in number of columns and I'm utilising the same Power Query to transform them.
If I use the "Remove Other Columns" wizard it hardcodes the column numbers which means when I use it for the next sheet it is trying to keep a non-existant column.
Is there anyway of saying in PQ to keep the first an alst column without referencing the column numbers?
Thanks.
Solved! Go to Solution.
Sure:
KeepColumns = {List.First(Table.ColumnNames(Name_of_your_previous_step)),List.Last(Table.ColumnNames(Name_of_your_previous_step))}, #"Removed Other Columns" = Table.SelectColumns(Name_of_your_previous_step,KeepColumns)
Sure:
KeepColumns = {List.First(Table.ColumnNames(Name_of_your_previous_step)),List.Last(Table.ColumnNames(Name_of_your_previous_step))}, #"Removed Other Columns" = Table.SelectColumns(Name_of_your_previous_step,KeepColumns)
Thanks for that Marcel
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |