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"}, {{_}}) }})
CNENFRNL
Community Champion
Community ChampionFirst, take a look at your xml file, why different data types appear at the same depth of node tree (timestamp and subtree in your example).
Secondly, use Table.ReplaceValue() to substitute Table value with some certain values.