Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Hi,
I dont think so.
Regards,
Kaushik Solanki