topic Multiple mapping records in QlikView https://community.qlik.com/t5/QlikView/Multiple-mapping-records/m-p/164860#M37406 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>I have basically 2 tables :</P><UL><LI>A FACT table containing ID_PROJECT and EUROS</LI><LI>A PRECISION table containing ID_PROJECT and RESPONSABILITY_CENTER</LI></UL><P></P><P>The point is getting EUROS by RESPONSABILITY CENTER.<BR />I've tried lookup, but i have several RC for the same PROJECT.<BR />Ive tried ApplyMap, but still the same issue.</P><P>MAP_PRJ_CA:<BR />MAPPING LOAD<BR /> [Project ID] as ID_PRJ_TIME_MAP,<BR /> CA as CA_MAP<BR />FROM<BR />referentials\clients\PROJETS_PORTICO.csv<BR />(txt, codepage is 1252, embedded labels, delimiter is ';', msq)<BR />WHERE Période = 'MARCH';</P><P>FACT:<BR />LOAD<BR />ResourceDriverSplit as EUROS<BR />ApplyMap('MAP_PRJ_CA', [Project ID], NULL()) as CA,</P><P>I need your help !</P><P>Many thanks in advance for ur replies.</P><P></P></BODY></HTML> Wed, 16 Mar 2011 17:36:26 GMT 2011-03-16T17:36:26Z Multiple mapping records https://community.qlik.com/t5/QlikView/Multiple-mapping-records/m-p/164860#M37406 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>I have basically 2 tables :</P><UL><LI>A FACT table containing ID_PROJECT and EUROS</LI><LI>A PRECISION table containing ID_PROJECT and RESPONSABILITY_CENTER</LI></UL><P></P><P>The point is getting EUROS by RESPONSABILITY CENTER.<BR />I've tried lookup, but i have several RC for the same PROJECT.<BR />Ive tried ApplyMap, but still the same issue.</P><P>MAP_PRJ_CA:<BR />MAPPING LOAD<BR /> [Project ID] as ID_PRJ_TIME_MAP,<BR /> CA as CA_MAP<BR />FROM<BR />referentials\clients\PROJETS_PORTICO.csv<BR />(txt, codepage is 1252, embedded labels, delimiter is ';', msq)<BR />WHERE Période = 'MARCH';</P><P>FACT:<BR />LOAD<BR />ResourceDriverSplit as EUROS<BR />ApplyMap('MAP_PRJ_CA', [Project ID], NULL()) as CA,</P><P>I need your help !</P><P>Many thanks in advance for ur replies.</P><P></P></BODY></HTML> Wed, 16 Mar 2011 17:36:26 GMT https://community.qlik.com/t5/QlikView/Multiple-mapping-records/m-p/164860#M37406 2011-03-16T17:36:26Z Multiple mapping records https://community.qlik.com/t5/QlikView/Multiple-mapping-records/m-p/164861#M37407 <HTML><HEAD></HEAD><BODY><P>Probably you have to use your fact table as mapping table as:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />FACT:<BR />MAPPING LOAD<BR /> [Project ID],<BR /> ResourceDriverSplit // Euros<BR />FROM ... ;<BR /><BR />MAPPED:<BR />LOAD<BR /> CA,<BR /> ApplyMap('FACT', [Project ID], NULL()) as MAPPED_EUROS<BR />FROM ....;<BR /><BR /></PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Wed, 16 Mar 2011 18:08:43 GMT https://community.qlik.com/t5/QlikView/Multiple-mapping-records/m-p/164861#M37407 tresB 2011-03-16T18:08:43Z