Table indexing

[Anonymous]

I know I can access access data in a table as follow ...Table[column]{#}

where # is any number but just one.  is there any way to include two columns or to enter to numbers of rows? something like table[[column1,column2]]{0,1,2}

I know that is not gonna work but I hope you get what I am trying to do and show me a way out

Thnkas!

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

You could add an index column to filter rows. And use "Choose column" feature to filter columns or go to the specific column.

[CNENFRNL]

Hi, @Anonymous , access to a specific column/row/cell is really a pain in the axx compared with Excel; sometimes it could be as verbose as such, (supposing we need "Column1", "Column2" from table)

Table.SelectColumns(table, List.Select(Table.ColumnNames(table), each Text.End(_, 1) <= "2"))

Annoying as it is, it provides some flexibilies and code robust in the meantime.

M language would be more fun if only MS provided a full, more delicated set of documentation!

[Fowmy]

@Anonymous 

Say your table looks like:

You insert a step as 

= Table.FirstN(Table.SelectColumns(Source, {"Column1", "Column2"}),3)

Full Code which you can paste in a blank query:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("NY3LFcAgCAR74ewh+MFQi8/+2wgj5uA+3GHZtaRLEa0h8w1xZFTZZYmDXEMqXB8mPWjiGoY2og7yTN35P3i+SQjx+qDEWLEkx2CbymbZtvcH", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t, Column4 = _t, Column5 = _t]),
    Custom1 = Table.FirstN(Table.SelectColumns(Source, {"Column1", "Column2"}),3)
in
    Custom1

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn