Fuzzy/approximate string comparison in an expression?

[#1]

Hi guys. I'm doing some work in QlikView to compare data from two databases. I'm doing something like if(db1.field1 <> db2.field1, 'Error', 'OK) to compare the data between the two tables. It seems though that the encoding is different, so some special characters or something are causing it to return false when the text looks to be the same. Is there a way to do a sort of fuzzy or approximate string comparison? So it's not so strict as using <>?

[#2]

Hi ,

I can list down functions we used to a job which is very much similar to what you stated .

What you can do is extract tables into QVD & then compare text using wlidmatch / Trim / Mixmatch functions.

if you can give example , then we can resolve faster.

Cheers,

Bhushan N