Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
sai_katare
Contributor III
Contributor III

comparing text in two columns

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.

 

 

Labels (2)
1 Reply
Claudiu_Anghelescu
Specialist
Specialist

Create a new table in Load Script using :
Load ....
Where Exists (Customer_name1, Customer_name2);
To help community find solutions, please don't forget to mark as correct.