1 Reply Latest reply: Dec 2, 2009 3:52 PM by Miguel Angel Baeyens de Arce RSS

    MAP

    Slash69

      Dear All,

      in this code:


      tab:
      lOAD *
      iNLINE [
      CAMPOb , CAMPOa
      A ,bA
      A,LL
      AA, cc
      GG , k
      GG, z
      A, VV
      ];


      MAPPA:
      MAPPING LOAD
      CAMPOa AS CMP01
      , CAMPOb AS CMP02
      resident tab;

      Load
      CAMPOb,
      ApplyMap('MAPPA' ,'A') as steff
      resident tab;

      I would to extract All field is linked to "A".

      I axpected like result:

      ba, LL, VV in a field called steff
      , but doesn't work

      Please some help?

      Thanks

      Slasj

       

        • MAP
          Miguel Angel Baeyens de Arce

          Hello,

          You should use ApplyMap in the where statement instead of fields:

           

          InitialData:LOAD * INLINE [ CAMPOb, CAMPOa A, bA A, LL AA, cc GG, k GG, z A, VV];Map:MAPPING LOAD CAMPOa AS CMP01, CAMPOb AS CMP02RESIDENT InitialData;Result:LOAD CAMPOa AS STEFFRESIDENT InitialDataWHERE ApplyMap('Map',CAMPOb) = 'A';