10 Replies Latest reply: Jan 30, 2014 1:41 AM by kavita k RSS

    ApplyMap is not working with SQL

      Following is the code i have written but its giving an error "Field not found - <STATUS>"

       

      Can anybody please help me to solve this???

       

      Status_Map :

      MAPPING LOAD

      STATUS,

      NAME;

      SQL SELECT "STATUS",

          "NAME"

      FROM "STATUS_TABLE";

       

      abc:

      mapping load

      "STATUS",

      ApplyMap('Status_Map',"STATUS") as status;

      SQL SELECT "ID",

          "STATUS",

      FROM "XYZ";