Forum Discussion
Expand column containing both text and table types
Hi, I have an XML file where almost all columns contain mostly tables and can be expanded easily in the UI. However some columns contain both text and table types. An example: ...
Hi,
You can use below code in a step in the Query Editor.
Table.TransformColumns(Source, {{“Column1”, each if Value.Is(_, type table) then _ else #table({“Column1”}, {{_}} ) }} )Reference:
https://www.thebiccountant.com/2017/07/25/how-to-expand-a-column-that-cannot-be-expanded-in-power-bi-and-power-query-in-excel/
Written by ImkeFPrateek Raina
Hi,
You can use below code in a step in the Query Editor.
Table.TransformColumns(Source, {{“Column1”, each if Value.Is(_, type table) then _ else #table({“Column1”}, {{_}} ) }} )
Reference:
https://www.thebiccountant.com/2017/07/25/how-to-expand-a-column-that-cannot-be-expanded-in-power-bi-and-power-query-in-excel/
Written by ImkeF
Prateek Raina
Thanks - worked like a charm!