6 Replies Latest reply: May 23, 2017 9:05 AM by Simone Trabattoni RSS

    Mapping load based on another field

    Simone Trabattoni

      Hi community,

      I'm stuck in a mapping load that I cannot manage.

      The data I got are something like:

       

      LOAD *

      Inline

      [data,name,

      'IT','Italy'

      'DE','Germany'

      'FR','-'

      'US','-'

      ];

       

      The "name" field is incomplete as you can see. I'd like to have this result.

       

      LOAD *

      Inline

      [data,name,

      'IT','Italy'

      'DE','Germany'

      'FR','France'

      'US','United States of America'

      ];

       

      I've read a bit of documentation

       

      ApplyMap - script function ‒ Qlik Sense

       

      I've thought that I need to map the table basing the mapping on the field "data", but, due my few experience with mapping, I cannot do it.

      Thanks for your time