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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2016-02-25 04:52 AM

TMAP string handling

Hi all,

My input is XML and target is postgresql. In input there are upper case and lower case letters. Example:- LION, TIGER, elephant.
I need to compare it with lookup file(.csv) file and if the input vlalue match up with .csv file, then the value from input will be saved to target or its a rejected value. The problem i'm facing here is in .csv file the values will be lion, tiger, ELEPHANT. So i tried string handling to uppercase or all values to lowercase in tmap. If so the format will be changed to either uppercase or lowercase. I'm unable to get desired output. I'm using TOS 5.6.2. My output should be if in source, value is TIGER and in lookup the value is tiger, the output should be TIGER and if in input, value is elephant and in lookup the value is ELEPHANT, the output should be elephant. Can anyone help me out.

Labels (2)
Labels
189 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2016-02-25 12:17 PM
Author

one way to solve this is to generate a new column for joining while keeping the old column also in the flow. something like this should work:

0683p000009MH9Q.png
189 Views
0 Likes