Forum Discussion
Solved
Unir filas en una celda en Power Query
Hola!
a ver si alguien me puede ayudar tengo la siguiente tabla:
y necesito obtener el siguiente resultado:
no se como concatenar las líneas de tipo según la Orden.
Muchas gracias!
Copy this in a blank query
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCs7NLMlQ0lFyVIrViVbyySxOBHKcwByYlDMKzwVZoSuY45tYVJyRmJMDFHBDF3BHF/BAF/BUio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Emp = _t, Alphabet = _t]), #"Grouped Rows" = Table.Group(Source, {"Emp"}, {{"Temp", each _, type table [Emp=nullable text, Alphabet=nullable text]}}), #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each [Temp][Alphabet]), #"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Custom", each Text.Combine(List.Transform(_, Text.From), ", "), type text}), #"Removed Columns" = Table.RemoveColumns(#"Extracted Values",{"Temp"}) in #"Removed Columns"
2 Replies
- Vijay_A_Verma
Most Valuable Professional
Copy this in a blank query
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCs7NLMlQ0lFyVIrViVbyySxOBHKcwByYlDMKzwVZoSuY45tYVJyRmJMDFHBDF3BHF/BAF/BUio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Emp = _t, Alphabet = _t]), #"Grouped Rows" = Table.Group(Source, {"Emp"}, {{"Temp", each _, type table [Emp=nullable text, Alphabet=nullable text]}}), #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each [Temp][Alphabet]), #"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Custom", each Text.Combine(List.Transform(_, Text.From), ", "), type text}), #"Removed Columns" = Table.RemoveColumns(#"Extracted Values",{"Temp"}) in #"Removed Columns"no lo he probado tiene toda la pinta de un virus, cuidado
