Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My case:
i developped a route calling cTalendjob and merging 2 sources : 1 XML and 1 correlation table SQL Server. My final output of this process will be a XML.
My problematic: i want to lookup values from the correlation table (SQL Server). What would be the best practice for that ?
I already tried:
but i did not succed to have multiple input : XML and Table in the same tHMap
I think it will be a good idea but i cannot find where to define the datasource name when i'll deploy into the karaf runtime. May be this functionnality will be deprecated in the future ? (in reference to DatabaseUpdate https://help.talend.com/r/en-US/8.0/data-mapper-functions-reference-guide/databaseupdate-function)
At the moment, i found only one solution to use tRouteInput -> tXMLMap and lookup values from table -> tHMap for the final XML rendering. but it's a bit ugly....
Thank's in advance for sharing your experience
regards
Hello,
Here is a KB article about: how to access Talend Data Mapper from within Talend Studio, and explains how to create structures and maps that allow you to parse an XML file.
https://community.talend.com/s/article/Talend-Data-Mapper-Intro-Part-Using-the-Data-Mapper-Usiyf
Feel free to let us know if it helps.
Best regards
Sabrina