Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

deerhunter
Contributor

SUBSET RATIO @ 0% 2 tables, Attempting a names match with no success

FIXED

Thanks in advance team

1 Reply
deerhunter
Contributor

Re: SUBSET RATIO @ 0% 2 tables, Attempting a names match with no success

What is the best way to associate a string field FullName, that was created using:

     lastname,

     firstname,

     Upper(Trim(lastname)) & ' ' & Upper(Trim(firstname)) as FullName

from two tables?

I also tried converting it to: Upper(Trim(FullName)) as FullName

     within a preceding load

Resulting in no FullName matches where there should 25

Any ideas out there?