8 Replies Latest reply: May 18, 2013 6:45 AM by James Clark RSS

    Help on Applymap Statement

      Hi Community

       

      I have a problem with an applymap statement as it's not applying the map for some reason and i am lost why it's not working hopefully you can help me

       

      the code is as below:

       

      //******************************************************************************** LOAD MAPPING TABLES ***********************************************************************************//

       

       

      KACParentAccountDetails:

      Mapping

      LOAD CompanyDetails.CompanyCode,

           CompanyDetails.AccountContractManagerName

      FROM

      C:\Users\Manager\Dropbox\Qlikview\KA\KACParentAccountDetails.qvd

      (qvd);

       

       

      //******************************************************************************** LOAD MAIN DATA TABLES ***********************************************************************************//

      KAmaster:

      LOAD CompanyDetails.CompanyID,

           CompanyDetails.CompanyCode,

           CompanyDetails.ParentAccountID,

           Applymap('KACParentAccountDetails',CompanyDetails.ParentAccountID,'') as ContractManagerName,

           CompanyDetails.AccountContractManagerName

      FROM

      C:\Users\Manager\Dropbox\Qlikview\KA\CompanyDetails.qvd

      (qvd)