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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
since_1995
Contributor III
Contributor III

How to pass the unique id

Hello,

 

can you please help me with the following query

 

I have two columns cust id and cust location I have used trest and found the coordinates of customer location , using the textractjson I have extracted the lat and longitude. But I need the cust id. How can I pass it

 

my design:

 

tfiledelimited—tmap—treplace—tflowtoiterate—trest-textractjson-tlogrow

 

received output

 

formated_address—lat—lon

 

required output

 

cust id—formatted_address—lat—long

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi

You can use a tMap after textractJson component, add a new column called cust_id and set its expression like (for example): (String)globalMap.get("row3.cust_id")

//row3 is the flow ​name before tflowtoiterate, cust_id is one of the column name on treplace

 

Please try and let me know if you have any questions.

 

Regards

Shong

 

View solution in original post

1 Reply
Anonymous
Not applicable

Hi

You can use a tMap after textractJson component, add a new column called cust_id and set its expression like (for example): (String)globalMap.get("row3.cust_id")

//row3 is the flow ​name before tflowtoiterate, cust_id is one of the column name on treplace

 

Please try and let me know if you have any questions.

 

Regards

Shong