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!
