Discussion Board for collaboration on QlikView Scripting.
I been posed by this question by a colleague.
here is the scenario.
there three tables
and the requirement is i need to use these three tables and create a new table where i just need the first coloumns from the three tables.
Please help me with this.
the out put could be like this as per the question
i thought of using a link table to connect all three but i am not sure whether i am taking the correct approach or not.
Please guide me through it
Go to Solution.
Then use like this
It will create Cartesian product for you.
Using what logic you want A E and F in Table 4... Can you please elaborate little more on this?
Honestly i am not after any specific logic i am curious to know in what ways this can achieved.
A link table would also need some common columns
Any other workarounds if any please
You can even use
concatenate instead of join.
For other work arounds
Load *, RowNo() as No Inline
Load Field Resident T1 Where No = 1;
Load Field Resident T2 Where Match(No,1,2);
Drop Tables T1, T2, T3;