How to join table with different values in cloumns

[gawden01]

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]

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

[gawden01]

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

[kaushiknsolanki]

Hi,

I dont think so.

Regards,

Kaushik Solanki