Forum Discussion
Special Transpose to get output
Hi , I need to transpose a dataset to get a specific value. Here is my Input table Below is my output table. For each ticket in the input table I need to get the key values as colum...
Anonymous Can you just Pivot the Key column?
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQwVNJRcnQEEoZKsTpwAScgUZKRiizkDFJjZAwVMoJpMzJBFgHpS0xKRhaC6IOKGMNtQxEBaTMyNkEWAmlzdHFGFnIBEmUpSrGxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Tickets = _t, Key = _t, Value = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Tickets", Int64.Type}, {"Key", type text}, {"Value", type text}}), #"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Key]), "Key", "Value") in #"Pivoted Column"
Greg_Deckler
Community Champion
Community ChampionAnonymous Can you just Pivot the Key column?
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQwVNJRcnQEEoZKsTpwAScgUZKRiizkDFJjZAwVMoJpMzJBFgHpS0xKRhaC6IOKGMNtQxEBaTMyNkEWAmlzdHFGFnIBEmUpSrGxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Tickets = _t, Key = _t, Value = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Tickets", Int64.Type}, {"Key", type text}, {"Value", type text}}),
#"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Key]), "Key", "Value")
in
#"Pivoted Column"Greg_Deckler I have tried this but I'm not getting the desired output as my dataset is huge, I'm just getting 0 and 1 in my output. The method of pivoting key field would work for small use cases. What do I do