6 Replies Latest reply: Nov 17, 2015 3:20 PM by Kurt Gulman RSS

    Can you apply map on fields created from previous apply maps?

    Kurt Gulman

      Hello, I am wracking my head over this one:

       

      I am trying to create a THIRD apply map script based on two successful fields created similarly from original fields but the third apply map doesn't seem to work/recognize the other two. Is there a work around or am I doing something incorrectly?

       

       

      Mapping_CC:

        Mapping LOAD

        [Department],

        [MPR Dept]

        FROM [\\ANALOG\USERS\WILM\kgulman\Desktop\Qlikview\Bryan Liz Project\Mapping\Table.xlsx]

        (ooxml, embedded labels, table is Sheet3);

       

      Mapping_AdHoc:

        Mapping LOAD

        [Concatenated],

        [Ad Hoc Flash]

        FROM [\\ANALOG\USERS\WILM\kgulman\Desktop\Qlikview\Bryan Liz Project\Mapping\Table.xlsx]

        (ooxml, embedded labels, table is Sheet3);

       

       

      LOAD [Cost Ctr],

           [CO Area],

           CONCATENATE,

           Department,

           SPENDTYPE,

           [Std Hier.],

           ApplyMap('Mapping_Site', [Std Hier.]) As [Local Site],

           ApplyMap('Mapping_CC', [Department]) As [MPR Dept]

          // ApplyMap('Mapping_AdHoc', ([Local Site]&[MPR Dept]),ApplyMap('Mapping_AdHoc',[MPR Dept])) As [Ad Hoc]