Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to create a 1 one column query based on another query without duplicate the query ?

Hi,    I have a long query (#1) resulting in a multi column table. I would like for different reasons to create a new query (#4) wich is the copy of column A of query #1 and to keep query #1 in my...
Need Help
  • HotChilli's avatar
    HotChilli
    5 years ago

    Make a new blank Query.

    Paste this (with your table name) in the advanced editor:

    let
    Source = #"TableX"[col1]
in
    Source

     That will give a list (which you can convert to table from the interface)

  • Anonymous's avatar
    Anonymous
    5 years ago

     

     

    let
    Source = #"TableX"[[col1]]
in
    Source

     

     

     

    using the double [[    and     ]] you get a column-table directly.

    But I don't think this solves the problem of performance

     

    Qualche miglioramento si può ottenere usando Table.Buffer  to wrapp the column-table

HotChilli's avatar
HotChilli
Community Champion
5 years ago

Make a new blank Query.

Paste this (with your table name) in the advanced editor:

let
    Source = #"TableX"[col1]
in
    Source

 That will give a list (which you can convert to table from the interface)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

     

     

    let
    Source = #"TableX"[[col1]]
in
    Source

     

     

     

    using the double [[    and     ]] you get a column-table directly.

    But I don't think this solves the problem of performance

     

    Qualche miglioramento si può ottenere usando Table.Buffer  to wrapp the column-table