Forum Discussion

Anonymous

Nov 08, 2017

Solved

Select column from atable

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 ?

Hi Kriss,

That could be like

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