Need help regarding comparing field values

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Need help regarding comparing field values

swuehl — Tue, 19 Jul 2016 19:10:48 GMT

Have a look at

Data Cleansing

topic Need help regarding comparing field values in QlikView

Need help regarding comparing field values

Re: Need help regarding comparing field values