Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
kevin5
Contributor
Contributor

Best practices tHMap lookup values

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:

  • tHMap multiple input

but i did not succed to have multiple input : XML and Table in the same tHMap

  • tHMAP : DatabaseLookup values

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

Labels (7)
1 Reply
Anonymous
Not applicable

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