Discussion Board for collaboration on QlikView Scripting.
Hello, my question is a little bit tricky but i think that easy to understand. I have 2 tables:
Prod No 1
Prod No 2
What I want is to merge them ion the script so I have:
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?
Go to Solution.
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)
Just put a join keyword between both load statement.
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