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

Announcements
Join us in Bucharest on Sept 18th 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