Extract data from XML field

One Star

Extract data from XML field

Any ideas please?
I have an ESB returning result in xml format
I would add my xml here but the forum doesn't seem to like it so here's a link to it
 gist.github.com/cAstraea/398add89c5afc2d42ce1
How can I extract each code value from this? Like 484816,484817
 I would add an image of my talend job but it seems the forum doesn't like it
http://prntscr.com/94i2un
 
One Star

Re: Extract data from XML field

I think I'm making some progress , just need to find a way to transform the tFileOutputXML_1 into an input ... tried to make on componentOk link it to an tFileInputXML_1 but don't know how to get it in the file name/stream -> globalMap.get( ???
The tFileoutputXML_1 file name is generated like "./data/" + context.execution_date_format + ".LogicarCreateSuccess.xml"
Anyone have any idea how I can transform an xml output into an input ?
One Star

Re: Extract data from XML field

Basically:
* create variable (global map or context variable) for directory+filename
* use variable in tFileOutputXML to create xml
* use same variable in tFileInputXML to call created xml in previous step
One Star

Re: Extract data from XML field

Hello junmilsso, I managed to get the data with textractxmlfields , what I'm missing now is a way to aggregate the data from either tfileoutpoutdelimited_1 or tfileoutputxml_3 to the data from tExtractXMLField2
For example the first 2 return a list of ids
8fcd5bfb-3f06-8472-4fa9-564c36342706
bc04e42c-2af0-dd6c-2ee4-564c35cd4e52
while the 2nd tExtractXMLField returns a list of codes
484851
484852
See this image for the job prntscr.com/94vzq5
How can I join the 2 together ?
I want to use the ids too look up in an accounts table and after use the codes from tExtractXMLField to update each account with that id with the code returned in the same order presented so for the id 8fcd5bfb-3f06-8472-4fa9-564c36342706 I would update a field in accounts with 484851, for bc04e42c-2af0-dd6c-2ee4-564c35cd4e52 with  484852 and so on . I'm thinking iterate and tMysqlRow might be involved but not sure how to tie it all up.
Any help would be much appreciated.
Thanks