2 Replies Latest reply: Apr 16, 2018 8:06 AM by Lorna Louw RSS

    Script assistance

    Lorna Louw

      hi guys,

       

      I have the following script which is working fine.

       

      now I want to compare ANOTHER table to "onlinebankingflaggedprofiles"...how would I do that? In fact, I need to repeat this multiple times


      Thank you

       

       

       

      ONLINE_FLAGGED:

      LOAD

      *

      ;

      SQL SELECT

      cast(seq_no as char)          AS REPORT_ID

      FROM

        customer_detail 

      ;

      LOAD *

      Where not Exists(REPORT_ID);

      SQL SELECT

         report_ID                   AS REPORT_ID,

          

           co_cde               as CO_CDE,

           ucn                  AS UCN,

           support_number       AS SUPPORT_NUMBER,

          

           UPPER(investigation_type)   AS INVESTIGATION_TYPE,

           report_date                 as REPORT_DATE ,

       

           UPPER(report_type)    AS REPORT_TYPE,

        

           UPPER(report_ID)            AS REPORT_COOKIE_ID, //TEST

           UPPER(user_type)    AS USER_TYPE,

          

         

           cookie                      AS COOKIE,

           UPPER(feedback_summary)     AS FEEDBACK_SUMMARY,

           UPPER(feedback_detail)      AS FEEDBACK_DETAIL,

           zob                         AS ZOB,

           UPPER(proactive_reactive)   AS PROACTIVE_REACTIVE,

           UPPER(file_sent_to)         AS FILE_SENT_TO ,

        primary_investigation_comment AS PRIMARY_INVESTIGATION_COMMENT,

        cookie_identification_method  as COOKIE_IDENTIFICATION_METHOD

      FROM

      onlinebankingflaggedprofiles