Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.

Labels (3)
3 Replies
vapukov
Master II
Master II

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

Anonymous
Not applicable
Author

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.

0683p000009M07p.jpg

 

vapukov
Master II
Master II

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