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.
