Forum Discussion

rimah's avatar
rimah
Frequent Visitor
4 years ago
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.
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    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))

     

rimah's avatar
rimah
Frequent Visitor
4 years ago

Thank you for your answer, But what if I want to remove columns that came between two other columns.

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

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))