topic Extract data from XML field in Talend Studio

Extract data from XML field

Anonymous — Thu, 19 Nov 2015 13:15:53 GMT

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

Re: Extract data from XML field

Anonymous — Fri, 20 Nov 2015 09:21:23 GMT

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 ?

Re: Extract data from XML field

Anonymous — Fri, 20 Nov 2015 09:27:48 GMT

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

Re: Extract data from XML field

Anonymous — Fri, 20 Nov 2015 14:04:02 GMT

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