XML Parsing technics

[mikaelhyensjo]

Hi.

We problems to parse attached XML file and need help finding the right tools to parse it.

Regards Mikael

[MarqueeCrew · Accepted solution]

@mikaelhyensjo,

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:

• Record Type
• Property
• Property_Name
• Property_IsReadOnly
• Property_ValueType

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

[mikaelhyensjo]

Thank You Mark 👍

[MarqueeCrew]

You're quite welcome.

Thanks for the challenge,

Mark