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!
