topic concatenating data set query in QlikView https://community.qlik.com/t5/QlikView/concatenating-data-set-query/m-p/204007#M61098 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>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.</P><P>I have three table A, B and C, which I'm concatenating into the master data set MASTER.</P><P>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.</P><P>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!</P><P>Hope this makes sense.</P><P>Thanks<BR />Nick</P></BODY></HTML> Mon, 07 Feb 2011 17:46:51 GMT 2011-02-07T17:46:51Z concatenating data set query https://community.qlik.com/t5/QlikView/concatenating-data-set-query/m-p/204007#M61098 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>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.</P><P>I have three table A, B and C, which I'm concatenating into the master data set MASTER.</P><P>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.</P><P>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!</P><P>Hope this makes sense.</P><P>Thanks<BR />Nick</P></BODY></HTML> Mon, 07 Feb 2011 17:46:51 GMT https://community.qlik.com/t5/QlikView/concatenating-data-set-query/m-p/204007#M61098 2011-02-07T17:46:51Z concatenating data set query https://community.qlik.com/t5/QlikView/concatenating-data-set-query/m-p/204008#M61099 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Has anyone got any ideas on this one? I thought I'd fixed it with a left join between tables B and C.</P><P>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 !!</P><P>Help appreciated!</P><P>Nick</P></BODY></HTML> Fri, 11 Feb 2011 16:24:09 GMT https://community.qlik.com/t5/QlikView/concatenating-data-set-query/m-p/204008#M61099 2011-02-11T16:24:09Z