Forum Discussion
Skip parsing blank XML
I have several XML columns in a table, but they can sometimes have no content. I either need to be able to: 1. Transform the XML column, but have Power Query be smart enough to skip blanks or at ...
Excel can't handle the data volume. I've spent many hours trying to use XPATH and XQUERY in SQL, but again my XML is so much more complicated than any examples that I can't expand them to meet my needs. Plus my XML is in a column, not a file, which seems to be rarely addressed.
At any rate, thanks.
Once you have the data ingested what is the next step - what are you planning to do with it? Is this a one-off report, or do you want to share that semantic model with others? Have you considered normalizing the data?