dynamic grouping

[chhoedhen]

dear all

while using table.group function or performing grouping, how to make all rows selected in the operations filed as dynamic,

when i have additional columnar data coming the hard coded column doesnot update accordingly

[latimeria]

Hi @chhoedhen ,

The issue is when expanding. Try Table.Combine instead.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUUqsAhJFQFylFKsTreQEZKVAcRpYxBnIyoDiZLAISFsWVE0FXFc2EJcAcTFcVybYDJDpIBEXICsfpKYIYlAsAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Group = _t, Column1 = _t, Column2 = _t, Column3 = _t]),
    #"Grouped Rows" = Table.Group(Source, {"Group"}, {{"Rows", each _, type table [Group=nullable text, Column1=nullable text]}}),
    #"Expanded Rows" = Table.Combine(#"Grouped Rows"[Rows])
in
    #"Expanded Rows"

Add a column, and it will be expanded without changing the code