Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hi-
I am struggling with post-xml parse issues and would really appreciate some direction to resolve the same.
Below is the XML file I am trying to parse , ingesting the file as-is and using the XML formatter the fields in yellow comes through fine - I then have to then use xml parser for a different field <aud_changes> which which has other information clubbed in ,as can be seen in the snippet below. I am able to parse that too and the 2nd snippet below shows the end result. However what i am struggling is the fields are not aligned in the output, meaning for the 2nd record aud_key=5378961 the <version> column is populated with old and new dates but that information is put in under <key_old> and <key_new> column. Is there any way i can get around this issue? Below is just an example actual data which has 80 column fields and a million rows. Thank you very much.
Solved! Go to Solution.
Probably it will not be very helpful , below is what i have. Also , correction on my previous comment - 241 fields after i split them as separate columns for <old> and <new> attributes. Original number of parent columns are ~100+.
