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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
AV2022
Contributor
Contributor

How to Update data based on mapping

Hello Team,

My requirement: I am trying to update the value in one of my Oracle output table based on the Input value from the Access DB.

Eg: Input Column has the below data

Column1 Column2 Column3 Column4

A B C D

My Expected output in Oracle output column should be based on Input value:

If the input value is A then output should be Anand

If the input value is B then output should be Boy

If the input value is C then output should be cat

if the input value is D then output should be dog

Output should have only one column and the data should be fetched on the mapping from the input table

Note: There are multiple Input Columns but single Output column.

I tried multiple ways to do this using tmap, but iam not getting how exactly i can do the mapping and generate the desired output with the help of expression builder. It would be great if u can help me with a solution.

Thanks

Anand

Labels (3)
1 Reply
AV2022
Contributor
Contributor
Author

Hi Team,

 

Can someone help me with my above query.

 

Thanks

Anand