Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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: