Select all columns in a table

[Flo_19]

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 !

[m_dekorte · Accepted solution]

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 · Accepted solution]

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!

[Flo_19]

That works too ! Thanks you @Syndicate_Admin ! 

[m_dekorte · Accepted solution]

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!

[Flo_19]

Thank you for your help and your reactivity @m_dekorte !