Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

lornafnb
Valued Contributor

Script assistance

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

2 Replies
shiveshsingh
Honored Contributor

Re: Script assistance

On what field do you want to compare? Can you elaborate a bit/>

lornafnb
Valued Contributor

Re: Script assistance

all/most of the comparison will be done on Report_id

Community Browser