comparing text in two columns

[sai_katare]

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.

[Claudiu_Anghelescu]

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