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
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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: 
omyahamburg
Creator II
Creator II
‎2013-07-10 03:32 AM

How to compare 2 text fields ?

Hi

I need to compare 2 text fields in 2 different tables.

One field I load from official UN Sanction list, the other one I load from my ERP masterdata.

  

I need to compare field "name" with "Name".

If any part of string in "name" is found in "Name", a flag should show 1.

I do attach a sample with inline tables. I would be happy if anyone can help me how to solve this.

regards

Joerg

test34.qvw
592 Views
0 Likes
2 Replies
tresesco
MVP
MVP
‎2013-07-10 03:51 AM

use SubStringCount() function.

406 Views
0 Likes
Not applicable
‎2013-07-10 04:16 AM

In response to tresesco

Please as i am getting below message when trying to post new message

Start New Discussion

Please note, your discussion will need to be approved by a moderator before it will be viewable by others.

 

     

   

406 Views
0 Likes