Hi,
I want to change Lists and Recors to Strings in PQ.
I am receiving data from an API and I have an Array and an Object Column like this:
let
soure_tmp = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wio7JiykBQTgDCJUSk5JjlHSQRVJSgSIwgVgdrLoKgQBJEYQRq6SjVB2Tp6AQo5SWWVRcEp+XmJsao2QF5HvlZ+SBrQFJ5iSiyAXnZpZkwCUzi+MTczLLwHIlRaWpUOHEdLCIkXmtUmwsAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ArrayCol = _t, ObjecCol = _t]),
#"Convert" = Table.TransformColumnTypes(soure_tmp,{{"ArrayCol", type text}, {"ObjecCol", type text}}),
#"SoureAPI" = Table.TransformColumns(#"Convert",{{"ArrayCol", Json.Document}, {"ObjecCol", Json.Document}})
in
#"SoureAPI"
Please note that the Step "Convert" is just for this example. I have to work with the Step "SourceAPI".
If I load them now to a normal ExcelSheet they look like this:
ArrayCol ObjecCol[List] [Record]
But I need them
ArrayCol
[[
"abc",
"dec"
],
[
"qqqq"
]
]
ObjecCol
{
"first_name": "John",
"last_name": "Smith",
"is_alive": true,
"age": 27}
Bookmarks