topic Re: Dynamic Join Key when using tMap in Talend Studio

Dynamic Join Key when using tMap

laughsmile — Mon, 24 Jun 2024 11:06:39 GMT

Hello everyone.

I am Configuring a tMap component to join two files, but the join keys are NOT fixed, the keys are dynamic and are read from the configuration file.

Therefore, I cannot set the key for the join in tMap, how can I solve this problem?

Thanks in advance

Ryu

Re: Dynamic Join Key when using tMap

HirisH_V7 — Mon, 24 Jun 2024 11:21:39 GMT

https://help.talend.com/en-US/components/8.0/tmap/tmap-tlogrow-tfileinputdelimited-tfileinputdelimited-linking-components-standard-component-you-have

Re: Dynamic Join Key when using tMap

laughsmile — Mon, 24 Jun 2024 13:24:45 GMT

Hello @HirisH_V7

Thanks for your comment.

Like the link which you commented , the join keys are dynamic and saved in the config file, so I can NOT drop the join keys from main input table to lookup table because I do not know the join keys(idState column) Unless I read the join keys from the config file.

Thanks

Re: Dynamic Join Key when using tMap

jeoste — Tue, 25 Jun 2024 13:18:35 GMT

hello
have you tried to check the box "reload at each row" on the lookup table? The configuration file is connected to your tMap?

Re: Dynamic Join Key when using tMap

laughsmile — Wed, 26 Jun 2024 05:20:11 GMT

Hello

The configuration file is not connected to tMap, I read join keys from configuration file and use tContextLoad to load join keys into Context parameters.

I think "reload at each row" option does not work, because the join keys in the main table which are read from configuration file are also dynamic .

Now , I solve the problem by using tJavaRow to add a new column whose value is the concatenation of join keys' value.

Ryu