Hi.
We problems to parse attached XML file and need help finding the right tools to parse it.
Regards Mikael
Solved! Go to Solution.
I read the xml file into a standard input tool and it parsed nicely for me. I deleted the entity field (all empty) and saw lots of repeating columns with Null() values. There were three (3) types of record types and it looked like the following fields could be used as part of a key:
I then TRANSPOSED the data into Name & Value pairs (by key) into data that should be easy to work with (especially a VIZ tool). I also deleted any records with a Null() Value.
Cheers,
Mark
Thank You Mark 👍
You're quite welcome.
Thanks for the challenge,
Mark
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |