Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
haribabugv
Creator
Creator

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

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

1 Reply
swuehl
MVP
MVP

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:

Easily managing global variables externally