In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to Dynamically Parse All Child Nodes with XML Parse Tool?

MARD_BT
5 - Atom

Dear Alteryx Forum, I’m trying to use the XML Parse Tool to extract all child nodes of a given parent node. So far, I’ve only found options to retrieve a single child by specifying Specific Child Names or using Auto Detect Child.

What I need is a more dynamic approach that works across different XML structures—even when the parent node is at varying levels or when child nodes have different names. Essentially, the solution should not rely on predefined child names and should adapt to changes in the XML hierarchy.

Has anyone implemented something like this or found a workaround?

Thanks a lot for your help.

Martin

1 REPLY 1
NeoInfiniTech
11 - Bolide

Hi @MARD_BT,

 

I recently developed a macro named NeoInfiniTech XML Parse that contains an XML parser I developed from scratch and parses all elements and attributes into a flattened tabular format while assigning a HierarchicalRecordID to all records.

 

Please take a look at it and see if it meets your needs.

Labels
Top Solution Authors