6 Replies Latest reply: Nov 21, 2017 4:41 AM by kumar rishikesh RSS

    Using Subfield in Applymap in Qliksense

    kumar rishikesh

      Hi,

      I have created a mapping table as mentioned below:

       

      Exceptions:

      mapping LOAD

           TRANSACTION_ID,

           date(timestamp#(DB_MODIFIED_DATETIME,'MM/DD/YYYY hh:mm:ss'))&'~'&

           date(timestamp#(DB_CREATED_DATETIME,'MM/DD/YYYY hh:mm:ss'))&'~'&

           RULE_NAME&'~'&

           date(timestamp#(DB_MODIFIED_DATETIME,'MM/DD/YYYY hh:mm:ss'))&'~'&

           EXCEPTION_STATUS as Exceptions

      Resident Temp;

      Drop Table Temp;

       

      I am using this mapping table in another load statement as :

       

      subfield(ApplyMap('Exceptions',TRANSACTION_ID,'NA'),'~',1) as Exception_Resolved_Date,

      subfield(ApplyMap('Exceptions',TRANSACTION_ID,'NA'),'~',2) as Exception_Created_Date,

      subfield(ApplyMap('Exceptions',TRANSACTION_ID,'NA'),'~',3) as RULE_NAME,

      subfield(ApplyMap('Exceptions',TRANSACTION_ID,'NA'),'~',5) as EXCEPTION_STATUS,

      subfield(ApplyMap('Exceptions',TRANSACTION_ID,'NA'),'~',4) as Exception_Created_Date_Open,

       

      But I am getting an error stating that Mapping ID not found.

       

      Please help.

      TIA

       

      Regards,

      Rishikesh