I'm concatenating a master data set from three tables and have a question on the best way to deal with a situation I have.
I have three table A, B and C, which I'm concatenating into the master data set MASTER.
Most of the data is fine. However, tables A and B have a ID field that I want in MASTER which Table C doesn't, as table C is linked into table B in our data structure. To confirm, I want this ID field against the table C records in MASTER.
So I have a foreign key in Table C linking to the primary key in Table B and the other ID that I want is in Table B. Easy to get to in SQL, but not sure of the best way to do this in Qlikview code. I could do a join, but is this best? I thinking there is almost definitely a more elegant way of doing it!
Has anyone got any ideas on this one? I thought I'd fixed it with a left join between tables B and C.
But this doesn't seem to allow me to have the ID held in the dataset against all records. I seem to get to the point where the ID is either held against the records from Table A or the records from Table C !!
