Forum Discussion

Flo_19's avatar
Flo_19
Frequent Visitor
3 years ago
Solved

Select all columns in a table

Hello everybody,

 

I'm currently searching to change the source of one table in the Advance Editor. 

 

My file 1 has the following source : 

Source = Csv.Document(File.Contents(\\dataview.fr\View\current_year\argos.csv),[Delimiter=";", Columns=37, Encoding=1252, QuoteStyle=QuoteStyle.None])

I want my second file (let's call it file 2) to source from file 1 : 

Source = Table.SelectColumns(#"file 1",{"Spec", "SI", "Serv", "Action", "Libel", "Date", ...})

 

There are a lot of columns in my file 1, do you know a faster and safer way to select all the columns in my file 1 ? Thank you !

 

 

Need Help
  • m_dekorte's avatar
    m_dekorte
    3 years ago

    Hi Flo_19,

     

    You can create a reference to file 1, that will always get you the final result from the File 1 query

    The code will look like this: Source = #"file 1"

     

    The easiest way to create a reference to another query is to right click the query you want to reference and select reference in the option list. Know that any future changes to File 1 will automatically flow through into your File 2 query

     

    Ps. Please mark this answer as solution when it helped you to resolve your question, thanks!

  • Syndicate_Admin's avatar
    Syndicate_Admin
    3 years ago

    Hi @Syndicate_Admin 

        Try in the Power Query -->Advance Editor

    let
    Source = Csv.Document(File.Contents(""),[Delimiter=",", Columns=37,Encoding=1252, QuoteStyle=QuoteStyle.None]),
    // Get column names from file 1
    columnNames = Table.ColumnNames(Source),
    // Source for file 2, selecting all columns from file 1
    Source2 = Table.SelectColumns(Source, columnNames)
    in
    Source2

     

    Ps. Please mark this answer as solution if it helped you to resolve your question, Thanks!

4 Replies

  • m_dekorte's avatar
    m_dekorte
    Resident Rockstar
    3 years ago

    Hi Flo_19,

     

    You can create a reference to file 1, that will always get you the final result from the File 1 query

    The code will look like this: Source = #"file 1"

     

    The easiest way to create a reference to another query is to right click the query you want to reference and select reference in the option list. Know that any future changes to File 1 will automatically flow through into your File 2 query

     

    Ps. Please mark this answer as solution when it helped you to resolve your question, thanks!

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    Hi @Syndicate_Admin 

        Try in the Power Query -->Advance Editor

    let
    Source = Csv.Document(File.Contents(""),[Delimiter=",", Columns=37,Encoding=1252, QuoteStyle=QuoteStyle.None]),
    // Get column names from file 1
    columnNames = Table.ColumnNames(Source),
    // Source for file 2, selecting all columns from file 1
    Source2 = Table.SelectColumns(Source, columnNames)
    in
    Source2

     

    Ps. Please mark this answer as solution if it helped you to resolve your question, Thanks!