topic Qlikview and Data modelling in QlikView https://community.qlik.com/t5/QlikView/Qlikview-and-Data-modelling/m-p/175931#M44137 <HTML><HEAD></HEAD><BODY><P>There are two approaches:</P><P>1) combine tables LIVRAISON_MD, COMMANDE_MD and OBJCMDE into one table</P><P>2) if 1 is not possible, load separate client information for each of the three above tables with different table names and different PK field names like:</P><P>LIVRAISON_CLIENT.LIVRAISON_CODECLI to LIVRAISON_MD.LIVRAISON_CODECLI</P><P>COMMANDE_CLIENT.COMMANDE_CODECLI to COMMANDE_MD.COMMANDE_CODECLI</P><P>OBJCMD_CLIENT.OBJCMDE_CODECLI to OBJCMDE.OBJCMDE_CODECLI</P><P></P></BODY></HTML> Thu, 26 Aug 2010 14:25:14 GMT 2010-08-26T14:25:14Z Qlikview and Data modelling https://community.qlik.com/t5/QlikView/Qlikview-and-Data-modelling/m-p/175930#M44136 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a problem with my data modelling because datas repeat themselves</P><P>Do you know any best pratices to avoid this problem</P><P>You can see my star modelling in attached file</P><P></P><P>Yours faithfully,</P><P></P></BODY></HTML> Thu, 26 Aug 2010 14:02:17 GMT https://community.qlik.com/t5/QlikView/Qlikview-and-Data-modelling/m-p/175930#M44136 2010-08-26T14:02:17Z Qlikview and Data modelling https://community.qlik.com/t5/QlikView/Qlikview-and-Data-modelling/m-p/175931#M44137 <HTML><HEAD></HEAD><BODY><P>There are two approaches:</P><P>1) combine tables LIVRAISON_MD, COMMANDE_MD and OBJCMDE into one table</P><P>2) if 1 is not possible, load separate client information for each of the three above tables with different table names and different PK field names like:</P><P>LIVRAISON_CLIENT.LIVRAISON_CODECLI to LIVRAISON_MD.LIVRAISON_CODECLI</P><P>COMMANDE_CLIENT.COMMANDE_CODECLI to COMMANDE_MD.COMMANDE_CODECLI</P><P>OBJCMD_CLIENT.OBJCMDE_CODECLI to OBJCMDE.OBJCMDE_CODECLI</P><P></P></BODY></HTML> Thu, 26 Aug 2010 14:25:14 GMT https://community.qlik.com/t5/QlikView/Qlikview-and-Data-modelling/m-p/175931#M44137 2010-08-26T14:25:14Z