Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Need Help! Data transformation

Hi, Could anyone please help me to transform data in desired output in Power BI.   Input Data ID COL1 COL1_Value COL2 COL2_Value COL3 COL3_Value 1 ServerName ABCDEF ServerName POI...
Need Help
smpa01's avatar
smpa01
Community Champion
7 years ago

You need to create a query called Table4 with the following code for the output to execute

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCk4tKkst8kvMTVWK1YlWcskszoZzHAsKcjKTE0sy8/OUYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Keywords to be searched for" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Keywords to be searched for", type text}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Keywords to be searched for", "Keywords to be searched for"}})
in
    #"Renamed Columns"
smpa01's avatar
smpa01
Community Champion
7 years ago

That's how it would look once you create two queries with the codes that I provided you.Table 2 is the desired output.