Posts: 2
Registered: ‎04-22-2021

qlik sense partitian comaration between 2 fields

I would greatly appreciate any help! I have this table:

Employee: Id, Name, Country.

I need to join between any row only if the country are the same, and only if there is At most one char that not matches in the name.

For example: emp1:(1, "ABCDE", "u.s.a") match to emp2: (2, "ABFDE, "u.s.a")

The change can be only in the same index,

Is there a function in qlik sense script that return a string consist of common chars of 2 columns? that will give me in this case of Qlik Sense Training the string ABD?

And after that I will check the length of this common string.

Thank you!