Forum Discussion
Solved
get row values on same cell
Hello altruists, I have table with different product's colour. I want for same product all colour to be in same cell in Power Query, separated by some character such as forward slash. Can someone...
sparvez Try this:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("hc8xCoAwDAXQu3S21/AILtIhpSEWalNCtHh7wQoOVtx+eMmHzLMZZYtqrRkMlJLwSsQpYDZu6LNg+DQSfF2yQKbGB6bE9dtbvHxCQgV/98LmUSjmNmXYj9+lukTtVSmvoPx84k4=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Type = _t, Produt = _t, Colour = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Type", type text}, {"Produt", type text}, {"Colour", type text}}), #"Grouped Rows" = Table.Group(#"Changed Type", {"Type", "Produt"}, {{"Colours", each _, type table [Type=nullable text, Produt=nullable text, Colour=nullable text]}}), #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Lines.ToText(Table.ToList(Table.SelectColumns([Colours], "Colour")),"/")) in #"Added Custom"
sparvez Try this:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("hc8xCoAwDAXQu3S21/AILtIhpSEWalNCtHh7wQoOVtx+eMmHzLMZZYtqrRkMlJLwSsQpYDZu6LNg+DQSfF2yQKbGB6bE9dtbvHxCQgV/98LmUSjmNmXYj9+lukTtVSmvoPx84k4=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Type = _t, Produt = _t, Colour = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Type", type text}, {"Produt", type text}, {"Colour", type text}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"Type", "Produt"}, {{"Colours", each _, type table [Type=nullable text, Produt=nullable text, Colour=nullable text]}}),
#"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Lines.ToText(Table.ToList(Table.SelectColumns([Colours], "Colour")),"/"))
in
#"Added Custom"the previous one already worked
