populate columns from tmap

Six Stars

populate columns from tmap

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 :

AddrID|AddrType|StatusCode|SuiteStatusCode|AddressTypeCode|Address|Suite|City|State|Zip|ZipType|Plus4|Latitude|Longitude|CountyName|RBDI|AddressErrorCode|AddressErrorString|CMRA|MSA|PMSA

 

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.

Forteen Stars

Re: populate columns from tmap

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

-----------
Six Stars

Re: populate columns from tmap

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.

IMG_20181002_133414356_HDR.jpg

 

Forteen Stars

Re: populate columns from tmap

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
-----------

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog