comparing text in two columns

sai_katare — Sat, 16 Nov 2024 20:21:17 GMT

Hi,

I have a requirement where I have two tables which I cannot join or lookup (currently)

Table1 has column: Customer_name, price

Table2 has column: Customer_name

Now, I am trying to write an expression where if customer name in table 1 matches with customer name in table 2 then show 'price'.

Please help me with the expression. I am trying getfieldselections, match etc in a set expression but unable to get the price for the give customer.

Thanks in advance.

Re: comparing text in two columns

Claudiu_Anghelescu — Tue, 06 Aug 2019 10:21:02 GMT

Create a new table in Load Script using :
Load ....
Where Exists (Customer_name1, Customer_name2);