Forum Discussion
Solved
Power query columns containing text data and tables
Good day I am new to you forum and would greatly appreciate your help. I have a xml. dataset but one of my columns contains tables as well as other text data. If I try to expand the tables, I get ...
Add a new step.
Paste this and alter this to suit your needs.
= Table.TransformColumns(YourPreviousStep, {{"DischargePortATA", each if Value.Is(_, type table) then _ else #table({"DischargePortATA"}, {{_}}) }})
Add a new step.
Paste this and alter this to suit your needs.
= Table.TransformColumns(YourPreviousStep, {{"DischargePortATA", each if Value.Is(_, type table) then _ else #table({"DischargePortATA"}, {{_}}) }})
I managed to get this to work, but the results yeild an exponentially large volume of rows, too much to handle, when the results get refreshed back into excel or PowerBi, after I expand the resulting table columns after this step. Could I be missing something?