Select all columns from the 3rd column - Power Query

[daniel95]

Hi,

I'm trying to select all columns from the 3rd column in Power Query such that whenever there's a new column added it is selected in the query as well.

In Macro a quick way to do this was to record "Cntrl + Shift + " from the third column.

 

[sandy666]

it's depend what you want to do

 

[GraH]

Hi,
Maybe this way?

Table.SelectColumns(Table, List.Range(Table.ColumnNames(Table),3))

 

[daniel95]

Hi,
Maybe this way?

Table.SelectColumns(Table, List.Range(Table.ColumnNames(Table),3))

Hi, Thanks for your prompt reply.

On trying that, there was an error that came up. attached screenshot below.

 

[sandy666]

I think you should read how M (Power Query) works

Power Query documentation - Power Query

Power Query is used to filter, combine, and mash up data from one or more supported data sources.

docs.microsoft.com

 

[GraH]

Hi, Thanks for your prompt reply.

On trying that, there was an error that came up. attached screenshot below.

View attachment 29082

In this case the code should be

, SelectCols = Table.SelectColumns(#"Filtered Rows", List.Range(Table.ColumnNames(#"Filtered Rows"), 3 ) )
in
SelectCols

PS: for future posts, don't post images but paste the code inside the code tages via the code features of the forum (M = Power Query language)