LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: moko

Im trying to parse an XML file in LAE using the "XML Data" node but due to the amount of columns it will output (over 700), the runtime for this node alone takes hours. And this is based on only a small sample of the actual XML dataset, which is also attached to this post (converted to .txt and zipped for uploading purposes )

Is there a way that I can decrease the runtime to a more reasonable level??

Thanks in advance,
Mick
Attachments:
Sample.zip

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dsc88dsc88

Just to add to this thread...

Using Excel we have identified that "the specified XML source does not refer to a schema". When Excel goes on to create a schema based on the XML source data, it also takes an 'unreasonable' amount of time to parse the XML file.

We tested another XML file we had lying around (containing 223 rows of data with circa 20 columns) and both LAE and Excel parsed the data in a couple of seconds.

Many Thanks,
David

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: moko

Ah yes, didnt pick up on that when viewing the file content. Thanks for the advice.

Mick