Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

ericarru
Contributor

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?

Tags (1)
1 Solution

Accepted Solutions

Re: Relate 2 Tables Without key

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

3 Replies

Re: Relate 2 Tables Without key

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
Contributor

Re: Relate 2 Tables Without key

Just put a join keyword between both load statement.

ericarru
Contributor

Re: Relate 2 Tables Without key

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

Community Browser