Forum Discussion
Solved
How can I Delete all columns that come Before a specific column (Column name)
Hello everyone, I want to know how can I dynamically Delete all columns that come Before a specific column (Column name) What code should I write! is it even possible? Thank you.
For between dynamic deletion (Here, I have removed all columns between Age and Salary)
Table.RemoveColumns(Source,List.Range(Table.ColumnNames(Source),List.Min({List.PositionOf(Table.ColumnNames(Source),"Age"),List.PositionOf(Table.ColumnNames(Source),"Salary")})+1,Number.Abs(List.PositionOf(Table.ColumnNames(Source),"Age")-List.PositionOf(Table.ColumnNames(Source),"Salary"))-1))
Greg_Deckler
Community Champion
Community Championrimah You can use this syntax to get the column number and you should then be able to use similar syntax to remove columns greater than that number.
Table.ColumnNames(MyTable){n}