topic Re: Apply map in App Development

topic Re: Apply map in App Development https://community.qlik.com/t5/App-Development/Apply-map/m-p/1146293#M20472 <HTML><HEAD></HEAD><BODY><P>Yes : </P><P></P><P>TablecorrespondanceSeg:</P><P>Mapping LOAD</P><P>    Machine,</P><P>    Segments</P><P>FROM [lib://NA/Table de correspondance NA.xlsx]</P><P>(ooxml, embedded labels, table is Segments);</P><P></P><P></P><P>TablecorrespondanceEndUser:</P><P>Mapping LOAD</P><P>    End_User1,</P><P>    "End User 2"</P><P>FROM [lib://NA/Table de correspondance NA.xlsx]</P><P>(ooxml, embedded labels, table is [End user]);</P><P></P><P></P><P></P><P></P><P>TablecorrespondanceEtat:</P><P>Mapping LOAD</P><P>    Etats, </P><P>    "Nom de l'état"</P><P>FROM [lib://NA/Table de correspondance NA.xlsx]</P><P>(ooxml, embedded labels, table is Etats);</P><P></P><P></P><P>TablecorrespondanceDDM:</P><P>Mapping LOAD</P><P>    Counties,</P><P>    "Area"</P><P>FROM [lib://NA/Table de correspondance NA.xlsx]</P><P>(ooxml, embedded labels, table is DDM);</P><P></P><P></P><P>TablecorrespondanceRange:</P><P>Mapping LOAD</P><P>    "AEM Range 1",</P><P>    "AEM Range 2" as "AEM Range"</P><P>FROM [lib://NA/Table de correspondance NA.xlsx]</P><P>(ooxml, embedded labels, table is Range);</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P>// **************************************** Traitement des données et jointures des tables ****************************************</P><P></P><P></P><P></P><P></P><P>Don:</P><P>LOAD</P><P>    Company_Number,</P><P>    Product_Id,</P><P>    Product_Label as 'AEM Range',</P><P>    Chart_Label,</P><P>    Activity_Label,</P><P>    Model_Label,</P><P>    "Year",</P><P>    Period as Month,</P><P>    Geography_Label as Counties,</P><P>    Customer_Type_Label,</P><P>    End_Use_Label,</P><P>    Applymap('TablecorrespondanceSeg',Model_Label,'Correspondance non trouvée : ' & Model_Label) as Segment,</P><P>    Applymap('TablecorrespondanceEndUser',End_Use_Label,'Correspondance non trouvée : ' & End_Use_Label) as "End user",</P><P>    if(right(Geography_Label,3)='ZFG' OR right(Geography_Label,3)='CFG', Applymap('TablecorrespondanceEtat',right(Geography_Label,3),'Correspondance non trouvée : ' & right(Geography_Label,3)), Applymap('TablecorrespondanceEtat',right(Geography_Label,2),'Correspondance non trouvée : ' & right(Geography_Label,2))) as "State name", </P><P>  if(right(Geography_Label,3)='ZFG' OR right(Geography_Label,3)='CFG', Applymap('TablecorrespondanceEtatRegroupement',right(Geography_Label,3),'Correspondance non trouvée : ' & right(Geography_Label,3)), Applymap('TablecorrespondanceEtatRegroupement',right(Geography_Label,2),'Correspondance non trouvée : ' & right(Geography_Label,2))) as Area, </P><P>    Applymap('TablecorrespondanceDDM',Geography_Label,'Correspondance non trouvée : ' & Geography_Label) as "DDM",</P><P>    'Yes' as "Adressable Market",</P><P>    "Count" as Gehl</P><P>FROM [lib://NA/*gehl*.txt]</P><P>(txt, codepage is 1252, embedded labels, delimiter is ',', msq)</P><P>Where Activity_Label='New Retails' and not WildMatch(Product_Id,'EX05','EXHC','IF21','IF23');</P><P></P><P></P><P>Concatenate</P><P></P><P>[................] </P><P></P><P></P><P></P><P>Thanks for your answer</P></BODY></HTML> Mon, 08 Aug 2016 09:56:06 GMT 2016-08-08T09:56:06Z Apply map https://community.qlik.com/t5/App-Development/Apply-map/m-p/1146291#M20470 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I have just upgraded qlik sense in 3.0 version and i have a problem with the "Apply map (attached picture). </P><P></P><P>Thanks for your answers, </P><P></P><P>Clément</P></BODY></HTML> Mon, 08 Aug 2016 08:39:00 GMT https://community.qlik.com/t5/App-Development/Apply-map/m-p/1146291#M20470 2016-08-08T08:39:00Z Re: Apply map https://community.qlik.com/t5/App-Development/Apply-map/m-p/1146292#M20471 <HTML><HEAD></HEAD><BODY><P>Would you be able to share the complete script?</P></BODY></HTML> Mon, 08 Aug 2016 09:40:23 GMT https://community.qlik.com/t5/App-Development/Apply-map/m-p/1146292#M20471 sunny_talwar 2016-08-08T09:40:23Z Re: Apply map https://community.qlik.com/t5/App-Development/Apply-map/m-p/1146293#M20472 <HTML><HEAD></HEAD><BODY><P>Yes : </P><P></P><P>TablecorrespondanceSeg:</P><P>Mapping LOAD</P><P>    Machine,</P><P>    Segments</P><P>FROM [lib://NA/Table de correspondance NA.xlsx]</P><P>(ooxml, embedded labels, table is Segments);</P><P></P><P></P><P>TablecorrespondanceEndUser:</P><P>Mapping LOAD</P><P>    End_User1,</P><P>    "End User 2"</P><P>FROM [lib://NA/Table de correspondance NA.xlsx]</P><P>(ooxml, embedded labels, table is [End user]);</P><P></P><P></P><P></P><P></P><P>TablecorrespondanceEtat:</P><P>Mapping LOAD</P><P>    Etats, </P><P>    "Nom de l'état"</P><P>FROM [lib://NA/Table de correspondance NA.xlsx]</P><P>(ooxml, embedded labels, table is Etats);</P><P></P><P></P><P>TablecorrespondanceDDM:</P><P>Mapping LOAD</P><P>    Counties,</P><P>    "Area"</P><P>FROM [lib://NA/Table de correspondance NA.xlsx]</P><P>(ooxml, embedded labels, table is DDM);</P><P></P><P></P><P>TablecorrespondanceRange:</P><P>Mapping LOAD</P><P>    "AEM Range 1",</P><P>    "AEM Range 2" as "AEM Range"</P><P>FROM [lib://NA/Table de correspondance NA.xlsx]</P><P>(ooxml, embedded labels, table is Range);</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P>// **************************************** Traitement des données et jointures des tables ****************************************</P><P></P><P></P><P></P><P></P><P>Don:</P><P>LOAD</P><P>    Company_Number,</P><P>    Product_Id,</P><P>    Product_Label as 'AEM Range',</P><P>    Chart_Label,</P><P>    Activity_Label,</P><P>    Model_Label,</P><P>    "Year",</P><P>    Period as Month,</P><P>    Geography_Label as Counties,</P><P>    Customer_Type_Label,</P><P>    End_Use_Label,</P><P>    Applymap('TablecorrespondanceSeg',Model_Label,'Correspondance non trouvée : ' & Model_Label) as Segment,</P><P>    Applymap('TablecorrespondanceEndUser',End_Use_Label,'Correspondance non trouvée : ' & End_Use_Label) as "End user",</P><P>    if(right(Geography_Label,3)='ZFG' OR right(Geography_Label,3)='CFG', Applymap('TablecorrespondanceEtat',right(Geography_Label,3),'Correspondance non trouvée : ' & right(Geography_Label,3)), Applymap('TablecorrespondanceEtat',right(Geography_Label,2),'Correspondance non trouvée : ' & right(Geography_Label,2))) as "State name", </P><P>  if(right(Geography_Label,3)='ZFG' OR right(Geography_Label,3)='CFG', Applymap('TablecorrespondanceEtatRegroupement',right(Geography_Label,3),'Correspondance non trouvée : ' & right(Geography_Label,3)), Applymap('TablecorrespondanceEtatRegroupement',right(Geography_Label,2),'Correspondance non trouvée : ' & right(Geography_Label,2))) as Area, </P><P>    Applymap('TablecorrespondanceDDM',Geography_Label,'Correspondance non trouvée : ' & Geography_Label) as "DDM",</P><P>    'Yes' as "Adressable Market",</P><P>    "Count" as Gehl</P><P>FROM [lib://NA/*gehl*.txt]</P><P>(txt, codepage is 1252, embedded labels, delimiter is ',', msq)</P><P>Where Activity_Label='New Retails' and not WildMatch(Product_Id,'EX05','EXHC','IF21','IF23');</P><P></P><P></P><P>Concatenate</P><P></P><P>[................] </P><P></P><P></P><P></P><P>Thanks for your answer</P></BODY></HTML> Mon, 08 Aug 2016 09:56:06 GMT https://community.qlik.com/t5/App-Development/Apply-map/m-p/1146293#M20472 2016-08-08T09:56:06Z Re: Apply map https://community.qlik.com/t5/App-Development/Apply-map/m-p/1146294#M20473 <HTML><HEAD></HEAD><BODY><P>I am not seeing anything wrong in your script. Did this problem come up after you started using 3.0 and was this working before?</P></BODY></HTML> Mon, 08 Aug 2016 12:46:23 GMT https://community.qlik.com/t5/App-Development/Apply-map/m-p/1146294#M20473 sunny_talwar 2016-08-08T12:46:23Z Re: Apply map https://community.qlik.com/t5/App-Development/Apply-map/m-p/1146295#M20474 <HTML><HEAD></HEAD><BODY><P>Yes it was working before, the problem appeared when i have upgraded in 3.0. </P></BODY></HTML> Mon, 08 Aug 2016 12:59:25 GMT https://community.qlik.com/t5/App-Development/Apply-map/m-p/1146295#M20474 2016-08-08T12:59:25Z Re: Apply map https://community.qlik.com/t5/App-Development/Apply-map/m-p/1146296#M20475 <HTML><HEAD></HEAD><BODY><P>It's it was a problem with a mapping table (i make a mistake). </P><P></P><P>Thanks for your answers</P></BODY></HTML> Mon, 08 Aug 2016 14:46:30 GMT https://community.qlik.com/t5/App-Development/Apply-map/m-p/1146296#M20475 2016-08-08T14:46:30Z Re: Apply map https://community.qlik.com/t5/App-Development/Apply-map/m-p/1146297#M20476 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I cannot see anything wrong with your script either, but I have had this error after an upgrade to 3.0 & have managed to fix it.  It looks like previous versions were more tolerant than 3.0, I had an Apply_Map to a mapping that didn't exist which was working fine before the upgrade.</P><P></P><P>To test the hypothesis, copy the project to another file & comment out the Apply_Maps, then re-run.  If this works, add them in one by one until it fails - it worked for me & I've added details in case anyone else has this error & finds this question as I did.</P><P></P><P>Regards, Stewart</P></BODY></HTML> Mon, 08 Aug 2016 15:00:36 GMT https://community.qlik.com/t5/App-Development/Apply-map/m-p/1146297#M20476 Anonymous 2016-08-08T15:00:36Z