Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
haribabugv
Contributor

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
MVP
MVP

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

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