topic populate columns from tmap in Talend Studio

populate columns from tmap

Anonymous — Thu, 27 Sep 2018 08:42:54 GMT

I have an input file with multiple columns along with address. Now that I am using a tmap followed by tmelissadataAddress component , I am only getting 5 output ports namely, address, city, state , zip , county. I want rest all columns to be populated. I tried to use multiple tmap but it is not allowing me to join as it is oroiginating from the same tmap output.

Input columns :

output columns :

is there any way I can call tmelissadataAddress component in tmap directly ,

Any leads how it can be achieved.

Re: populate columns from tmap

vapukov — Fri, 28 Sep 2018 23:22:26 GMT

You can use multiple tMap if You store data into memory (tHash) or into a file

the flow not always must be continues line, simulating brakes you can achieve your goals

Re: populate columns from tmap

Anonymous — Tue, 02 Oct 2018 09:15:55 GMT

The below picture will give a better understanding :

from the tmelissaDataAddress , I am only getting all the columns except AddressID, but in the output I want AddressId as well because in the downstream it is required.

While I was trying to join the two tmaps it was not allowing me to do. I tried taking two different flows and then join but join criteria was missing.

Even I tried making different job and then calling it in the other job, but as the primary key column(Addressid) is not getting populated from the tmelissaDataAddress, I am stuck.

Re: populate columns from tmap

vapukov — Tue, 02 Oct 2018 09:23:24 GMT

this is not possible, you can not join connections from same source point

as I wrote above you could:

store both results into CSV files and than read both of them
instead of csv use tHash tHashInput