This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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
Then use like this
It will create Cartesian product for you.
View solution in original post
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;