Parse XML independent of nesting level

JasonFriedman

I have some XML, pasted below and also attached.

<suite>
<testcase id="001" kind="bvt">
<inputs>
<arg1>4</arg1>
<arg2>7</arg2>
</inputs>
<expected>11.00</expected>
</testcase>
<testcase id="002" kind="drt">
<inputs>
<arg1>9</arg1>
<arg2>6</arg2>
</inputs>
<expected>15.00</expected>
</testcase>
</suite>

I'd like Alteryx to ingest this as:

id kind arg1 arg2 expected
1  bvt  4    7    11
2  drt  9    6    15

I have a solution attached and pictured below:

First stepSubsequent step

That subsequent step would need to be repeated, I think, if the XML nesting was deeper.

Is there a solution that will work no matter how deep the nesting?

example.xml

XML parse for Jason F..yxmd

DavidP

ok, I see the problem.

If you're loading the file as an xml file in the input data tool, it gets parsed as an xml file. We don't want this.

As I said in my earlier posts, if you're using the parse xml macro, you should load the file as a csv with delimeter set as \0 and the box unchecked that says First Row Contains Field Names (as per the example workflow that I posted).

This step is really important. Without it, nothing else works.

The parse XML macro expects a field [Field_1] that contains all the XML. If you do this bit right, the rest should fall into place.