Dynamic Join Key when using tMap

[laughsmile]

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

[HirisH_V7]

https://help.talend.com/en-US/components/8.0/tmap/tmap-tlogrow-tfileinputdelimited-tfileinputdelimit...

[laughsmile]

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

[jeoste]

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

[laughsmile · Accepted solution]

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