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 :
AddrID|AddrType|StatusCode|Address|Suite|City|State|Zip of which Address|Suite|City|State|Zip are to be standardized and rest to get mapped as is from the source
is there any way I can call tmelissadataAddress component in tmap directly ,
Any leads how it can be achieved.
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
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.
this is not possible, you can not join connections from same source point
as I wrote above you could:
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema