2 Replies Latest reply: Aug 9, 2018 5:34 AM by Gabor Tarnoczai RSS

    How do i load data and create a new variable?

    Sarah Guzman

      I keep getting errors below.

       

      Can someone help me?

       

      MAP_MUKESH_GRADE_TO_COUNTRY:

      Mapping

      LOAD Grade, Country;

      SQL EXECUTE VLU_spGetLookUp 64, 'Conv Grade to Country Mukesh';

       

      MAP_MUKESH_REGION_TO_COUNTRY:

      Mapping

      LOAD Region, Country;

      SQL EXECUTE VLU_spGetLookUp 67, 'Region to Country';

      RENAME TABLE DATA_FINAL TO TEMP;


      NoConcatenate


      DATA_FINAL:

      LOAD *,

      ApplyMap('MAP_MUKESH_GRADE_TO_COUNTRY', Grade,

      ApplyMap('MAP_MUKESH_REGION_TO_COUNTRY', Region,

      '*** Mukesh Missing Mapping ***')

       

      ) as MukeshCountry

      RESIDENT TEMP;


      DROP TABLE TEMP;