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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mandyc
Contributor
Contributor

How to compare columns from two unrelated tables

Hello experts, I am new to qlik and I need to compare multiple columns from two unrelated tables to produce a column with dynamic outcomes. 

Both of my tables have millions of records, so I can't do a cartesian join. 

Table 1: travel_desitnation

Table 2: available_destinations

Input: user can select 1 or more destinations from table 1

Output: score each rows in table 2 to determine the proximity of its destination to the input destination(2) 

Please see example in attachment. Thank you in advance!  

 

0 Replies