topic Re: add column in QlikView

add column

Thu, 28 Mar 2013 11:19:40 GMT

hi,

I have 3 tables A , B and C. there is a link1 between A and B and link2 between B and C.

I want to add a column to C from A without showing the tables A and B.

is it possible?

alexandros17 — Thu, 28 Mar 2013 11:23:14 GMT

Can you explain better your aim?

Thu, 28 Mar 2013 11:36:15 GMT

Table C contains the foreign key of B and Table B contains the foreign key of A.

there is a column in A that I want to add to C without without viewing the tables A and B in the table viewer.

I hope it's clearer now

alexandros17 — Thu, 28 Mar 2013 11:41:48 GMT

You need to use Table B, try to :

left join

left Join

and verify results

Thu, 28 Mar 2013 11:44:14 GMT

ok i'll try, thank u so much for your interactivity