Forum Discussion

tilldunk's avatar
tilldunk
Frequent Visitor
9 years ago
Solved

Creating new table out of existing one

Hello,   I got a table with a time column and severeal component columns (in this example only five components, in reality distinctly more):     What I am trying to do is creating a new ta...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi tilldunk,

     

    You can try to add a blank query source with below formulas.

     

    let
    Source = Table.SelectColumns('Original Source Name',{'Column Name','Column Name2'})
in
    Source

    Sample:

    let
    Source = Table.SelectColumns(Sheet3,{"Country","Col A"})
in
    Source

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi tilldunk,

 

You can try to add a blank query source with below formulas.

 

let
    Source = Table.SelectColumns('Original Source Name',{'Column Name','Column Name2'})
in
    Source

Sample:

let
    Source = Table.SelectColumns(Sheet3,{"Country","Col A"})
in
    Source

 

Regards,

Xiaoxin Sheng

Naram's avatar
Naram
New Member
8 years ago

Hello,

Trying to create a new query from the existing "Master" Query using below formula:

let
Source = Table.SelectColumns('Original Source Name',{'Column Name','Column Name2'})
in
Source

which works fine, however I am looking to see if there is any other formula which would do the same but in a way that it will create the new query with a range of columns , for example Column 20- 67, basically not needing to write all the column names one by one.

 

Thank you in advance