Two tables with no common key and output is based ... - Qlik Community

haribabugv · ‎2017-09-30

Can some one help me to join two tables with no common key and output is based on these two tables.

It would be great if anyone can provide solution in qlikview script editor than in charts and expressions?

I have attached excel sheet where output is based on table 1 and table 2.

I am worried about the cartesian product when joining two tables without any common field

swuehl · ‎2017-09-30

Not really sure what you are trying to achieve here, but maybe it is easier to load all 5 values into variables instead of creating a data model.

edit: Loading excel data into variables:

Two tables with no common key and output is based on these two tables.