Forum Discussion
Anonymous
3 years agoNot applicable
Unpivot a column without side information
Hello, I am extracting a dataset from a php link. After splitting by delimiter i get one line with all data after unpivoting i end with these columns The value...
- 3 years ago
Hi Anonymous ,
please add an additional step to your query with the following formula:
Table.FromRows( List.Split( #"Name of your previous step here"[Value], 12 ) )Or paste the following code into the advanced editor and follow the steps:
let Source = Table.FromRows( Json.Document( Binary.Decompress( Binary.FromText("i45WMtQzUtJRMtQ1UorVAfFMwDwTKM8IxDWCSxqZgblA2VgA", BinaryEncoding.Base64), Compression.Deflate ) ), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Attribute = _t, Value = _t] ), #"Changed Type" = Table.TransformColumnTypes(Source, {{"Attribute", type number}, {"Value", type text}}), Custom1 = Table.FromRows(List.Split(#"Changed Type"[Value], 2)) in Custom1
ImkeF
3 years agoCommunity Champion
Correct Anonymous ,
that's how it works.