Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ericarru
Creator
Creator

Relate 2 Tables Without key

Hello, my question is a little bit tricky but i think that easy to understand. I have 2 tables:

Products:

Prod No 1

Prod No 2

and

Month:

1

2

3

4

What I want is to merge them ion the script so I have:

Products     Month

Prod No 1      1

Prod No 1      2

Prod No 1      3

Prod No 1      4

Prod No 2      1

Prod No 2      2

Prod No 2      3

Prod No 2      4

is there any way?

1 Solution

Accepted Solutions
sunny_talwar

I guess join them (there will be a Cartesian Product which isn't the best of things, but it will give you what you want)

Table:

LOAD Products

FROM ....;

Join (Table)

LOAD Month

FROM ....;

View solution in original post

3 Replies
sunny_talwar

I guess join them (there will be a Cartesian Product which isn't the best of things, but it will give you what you want)

Table:

LOAD Products

FROM ....;

Join (Table)

LOAD Month

FROM ....;

ganeshsvm
Creator II
Creator II

Just put a join keyword between both load statement.

ericarru
Creator
Creator
Author

Omg... I was looking for left, rights joins even inner and what i needed is just join.. xD Well, actually the cartesian prod is what I was looking for, thanks