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

Need help regarding comparing field values

Hi All, Need your help in following issue. I have 2 fields called Bank Name 1 and Bank Name 2 Both are coming from different sources having sbank name in fields ,but values inserted is not proper format followed .

e.g

Bank Name 1     Bank Name 2

HDFC Bank        HDFC Bank LTD

SBI                     State bank of india



So in above cases if i compare both fields then we must get value "YES" as both are same banks. But if I used "IF"

condition it will give only "NO " AS OUTPUT.

Please suggest me solution for this. Whether is it feasible to do.

Thanks in advance.

Regards,

Akshata

1 Reply
swuehl
MVP
MVP

Have a look at

Data Cleansing