Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I currently have the below format of data:
I would like to get it to look like something like this:
I tried to pivot columns and it gave me this:
Solved! Go to Solution.
Hi @ChrisHedges,,
Something like this?
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUfLKz8hTitWJVjICcRKTs8EcYyAnILE0B84Jy0zOrkSoy1eKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [incremental_id = _t, name = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"incremental_id", Int64.Type}, {"name", type text}}),
#"Duplicated Column" = Table.DuplicateColumn(#"Changed Type", "incremental_id", "incremental_id - Copy"),
#"Pivoted Column" = Table.Pivot(#"Duplicated Column", List.Distinct(#"Duplicated Column"[name]), "name", "incremental_id - Copy", (x)=>List.ContainsAny(#"Duplicated Column"[#"incremental_id - Copy"], x))
in
#"Pivoted Column"
Kind regards,
John
Hi @ChrisHedges,,
Something like this?
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUfLKz8hTitWJVjICcRKTs8EcYyAnILE0B84Jy0zOrkSoy1eKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [incremental_id = _t, name = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"incremental_id", Int64.Type}, {"name", type text}}),
#"Duplicated Column" = Table.DuplicateColumn(#"Changed Type", "incremental_id", "incremental_id - Copy"),
#"Pivoted Column" = Table.Pivot(#"Duplicated Column", List.Distinct(#"Duplicated Column"[name]), "name", "incremental_id - Copy", (x)=>List.ContainsAny(#"Duplicated Column"[#"incremental_id - Copy"], x))
in
#"Pivoted Column"
Kind regards,
John