SOLVED

Select column from atable

Deleted
Not applicable

Hi,

In the query editor I can load a "column 1" from "table 1" with this formula :

= Excel.CurrentWorkbook(){[Name="table 1"]}[Content][Column 1].

But is it a way to select more than 1 column ?

2 Replies
best response
Solution

Hi Kriss,

 

That could be like

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content][[Column1],[Column2]]
in
    Source

 

Hi Sergei,

Many thanks for your quick answer.

1 best response

Accepted Solutions
best response
Solution

Hi Kriss,

 

That could be like

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content][[Column1],[Column2]]
in
    Source

 

View solution in original post