Forum Discussion

K_H's avatar
K_H
New Member
4 years ago
Solved

Power Query – Importing selected columns from CSV

Hello, I am trying to import selected columns from a CSV file and exclude any columns that contain personal information. An example data set is below - columns B, D and F should be excluded.    ...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Unfortunately, this is the limitation of PQ...You can't control the order of columns to be imported. If you specify 4 columns, here then it will import first 4 columns. 

    {"ColumnA","ColumnC","ColumnE","ColumnG"} = This supplies names of columns to first 4 columns, it doesn't control which columns to be imported. Hence, first 4 columns will be imported and named "ColumnA","ColumnC","ColumnE","ColumnG". 

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Unfortunately, this is the limitation of PQ...You can't control the order of columns to be imported. If you specify 4 columns, here then it will import first 4 columns. 

{"ColumnA","ColumnC","ColumnE","ColumnG"} = This supplies names of columns to first 4 columns, it doesn't control which columns to be imported. Hence, first 4 columns will be imported and named "ColumnA","ColumnC","ColumnE","ColumnG".