Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Hierarchal XML Parsing and Size Usage

nbt1032
8 - Asteroid

I am working on a series of hierarcharl XML files.  In the example below I take one of the 50 files to be processed and transform the XML.  What is interesting is that the second step, creates 777,943 rows using 52mb, however the XML parse objects returns fewer rows, but uses alot more space. 

 

When I run this sample with all 50 files in the directory, Atleryx creates a temp database file that consumes all of my 500GB free HD space. 

 

Can anyone provide insight as to this memory usage, and why Alteryx builds a 78GB Engine directory in my temp folder to process a hierarchal XML file that is only 24mb?

 

Thanks,

Marc.

 

a1.png

3 REPLIES 3
andrewdatakim
12 - Quasar
12 - Quasar

When you are Parsing are you keeping the orignal XML, child values and outer XML? I have had this increase the file size exponentially before.

nbt1032
8 - Asteroid

I have Return Child XML and Return Outer XML set.   The magnitude of the growth really does not seem reasonable.  Can anyone from Alteryx comment on this and if this is a reasonable and expected result?

nbt1032
8 - Asteroid

I opened a ticket with Alteryx on this issue.  The resolution was simple.   When I disable all Browse Tools in the Runtime tab for the workflow configuration, all problems went away. 

 

"The browse tool can be a sneaky culprit for hogging resources.  Since the browse everywhere was introduced (the preview in the results window), many folks like to remove them once development is complete. "

 

 

Labels