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"
Vijay_A_Verma
Most Valuable Professional
Most Valuable ProfessionalCopy 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