Hierarchical stage - XML parsing
Moderators: chulett, rschirm, roy
Simpler solution --- work on dumping the entire response as a single "chunked" text column (like "myXMLresponse")... send it to a sequential file with NONE for delimiter and for quote character and make sure it looks "clean" (just like you have it up above).
Then pass it into the xmlInput Stage. You will have to map the xpath using the xml importer ---- but afterwards, with your Repetition Element of <R>, you will get a nice set of rows for each of the R's, and then can do usual DS techniques to pivot and get the piped output you are looking for. Don't try to do that pivoting inside of the Hierarchical Stage. Too complex to maintain, even if you can figure it out.
Ernie
Then pass it into the xmlInput Stage. You will have to map the xpath using the xml importer ---- but afterwards, with your Repetition Element of <R>, you will get a nice set of rows for each of the R's, and then can do usual DS techniques to pivot and get the piped output you are looking for. Don't try to do that pivoting inside of the Hierarchical Stage. Too complex to maintain, even if you can figure it out.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>