topic Join header & detail record in QlikView https://community.qlik.com/t5/QlikView/Join-header-detail-record/m-p/198511#M714517 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>In my RDBMS I have the structure of a header file containing a small number of fields then a detail table containing the detail, there can be many detail record per header record. This is fairly standard in a RDBMS structure. My question is , Is there a 'preferred'/'correct' method for creating one QV table containing all the data ? I am currently using a outer join.</P><P>Thanks,</P><P>Gavin.</P></BODY></HTML> Wed, 30 Dec 2009 17:50:13 GMT 2009-12-30T17:50:13Z Join header & detail record https://community.qlik.com/t5/QlikView/Join-header-detail-record/m-p/198511#M714517 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>In my RDBMS I have the structure of a header file containing a small number of fields then a detail table containing the detail, there can be many detail record per header record. This is fairly standard in a RDBMS structure. My question is , Is there a 'preferred'/'correct' method for creating one QV table containing all the data ? I am currently using a outer join.</P><P>Thanks,</P><P>Gavin.</P></BODY></HTML> Wed, 30 Dec 2009 17:50:13 GMT https://community.qlik.com/t5/QlikView/Join-header-detail-record/m-p/198511#M714517 2009-12-30T17:50:13Z