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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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