How to join table with different values in cloumns - Qlik Community

gawden01 · ‎2019-03-25

Hello,

I am trying to join 2 table where value in 1 table is in upper case and other in lower and vice versa.

How can I join them in during data loading or script?

kaushiknsolanki · ‎2019-03-25

Hi, You can use the string function like Upper() or Lower() to convert both the field values in similar case and then join them. For example.

Table1:

Load Upper(Field1) as Key,* from Table1;

Join

Load Upper(Field2) as Key,* from Table2;

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

gawden01 · ‎2019-03-25

Thanks,
Can I use where condition in scripting to join "like%'?

kaushiknsolanki · ‎2019-03-25

Hi,

I dont think so.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!