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: 
Anonymous
Not applicable

Need help replacing values in tMap (not conditional statement)

Hi,

 

This involves JIRA REST API if anyone is familiar, but even without knowledge I think some may be able to help.  I don't know if this is the best explanation, but basically I have a tREST call early in my job with an output of "1st JSON response" below.  later on in the job I have another tREST call going into a tMap.  This tREST call returns only EpicKey, so when this comes into the tMap I want to replace this with it's EpicName value.  I can't do if statements because the "1st JSON response" will be hundreds of rows and the values have potential to change.  I've tried to play around with tReplacelist and tReplace to no avail, but if this is what I need please let me know and I will try again.  If anyone has any advice or options on how to handle this it would be greatly appreciated!

 

1st JSON response                                 

Column     |  JSON query

-----------------------------------------------------

EpicKey    | "key"

EpicName |"fields.customfield_12222"

 

tMap desired output

When EpicKey comes in I want to replace with EpicName

Labels (3)
1 Reply
Anonymous
Not applicable
Author

Hi
Can you show an example of 1st Json response with several rows? Do you use a tExtractJsonField to extract the data from the response? Give us an real response and what are your desired output.

Regards
Shong