topic Re: Relate 2 Tables Without key in QlikView

Relate 2 Tables Without key

Anonymous — Thu, 22 Dec 2016 10:36:06 GMT

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:

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?

Re: Relate 2 Tables Without key

sunny_talwar — Thu, 22 Dec 2016 10:42:08 GMT

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 ....;

Re: Relate 2 Tables Without key

ganeshsvm — Thu, 22 Dec 2016 10:42:17 GMT

Just put a join keyword between both load statement.

Re: Relate 2 Tables Without key

Anonymous — Thu, 22 Dec 2016 12:15:00 GMT

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