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
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 ?
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
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