How to Extract Data from Multilayer XML Parent-Child Nodes to Form a List #79

Problem description & analysis

Below is data in XML file xml.xml:

To get categories and detailed data from the multilayer XML file and generate a two-dimensional table as follows:

Solution:

We write the following script p1.dfx in esProc:

Code description:

A1  Read data of the XML file as a string.

A2  Use xml function to get data of form layer and return it as a table sequence.

A3  Extend the multiple p.select.option values in table sequence A2 and concatenate them to generate a new table sequence.

A4  Export A3’s result to result.txt.

result.txt is the expected result after the script is executed.

Open source SPL source address

Download