Forum Discussion
Solved
Get API data in XML format and transform
Hello, I'm loading XML data from a legacy SOAP WS (great post here on how to get it). Some of the tags are empty and the Get Data interprets it as [Table] array. I need to get rid ...
danielsaf,
Please add an step into Advanced Editor of your query.#"expandcolumn"= Table.TransformColumns(yourpreviousstep , {{"LIMITED_PERMISSION", each if Value.Is(_, type table) then 0 else _ }} )
Regards,
Lydia
danielsaf,
Please add an step into Advanced Editor of your query.
#"expandcolumn"= Table.TransformColumns(yourpreviousstep , {{"LIMITED_PERMISSION", each if Value.Is(_, type table) then 0 else _ }} )
Regards,
Lydia
Excellent, exactely what I was looking for.
Is there a way to do it once for all columns or simply repeat the columns like this
#"Expandcolumn"= Table.TransformColumns(#"Removed Columns", {{"LIMITED_PERMISSION", each if Value.Is(_, type table) then 0 else _ },{"USER_ROLE", each if Value.Is(_, type table) then "" else _ }} ),danielsaf,
Please repeat this step for all the columns that you need to expand.
Regards,
Lydia