Implement OR condition in qlikview for 3 fields

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need to implement the below JOIN condition in Qlikview.

select

CLS_OUT_RPT_REQUEST_DTL.REQUEST_ID as REQUEST_ID,

CLS_OUT_RPT_REQUEST_DTL.CLS_OUT_RPT_ID as CLS_OUT_RPT_ID,

CLS_OUT_RPT_REQUEST_DTL.PO_NO as PO_NO,

CLS_OUT_RPT_REQUEST_DTL.CK_REQSTN_NO as CK_REQSTN_NO,

CLS_OUT_RPT_REQUEST_DTL.TOTALITY_ID as TOTALITY_ID,

CLS_OUT_RPT_REQUEST_DTL.REQUEST_TIMESTAMP as REQUEST_TIMESTAMP,

CLS_OUT_RPT_REQUEST_DTL.USR_EML_ID as USR_EML_ID,

THRD_PTY.TOTALITY_ID as TOTALITY_ID1,

THRD_PTY.TRANS_CAT_CD as TRANS_CAT_CD,

THRD_PTY.VER_NO as VER_NO,

THRD_PTY.THRD_PTY_LD_DT as THRD_PTY_LD_DT,

THRD_PTY.PO_NO as PO_NO1,

THRD_PTY.PO_VER_ID as PO_VER_ID,

THRD_PTY.CK_REQSTN_NO as CK_REQSTN_NO1,

THRD_PTY.TRANS_TYP_CD as TRANS_TYP_CD,

THRD_PTY.TRANS_SUB_TYP_CD as TRANS_SUB_TYP_CD,

THRD_PTY.THRD_PTY_LD_TYP_ID as THRD_PTY_LD_TYP_ID,

THRD_PTY.DT_PREPD as DT_PREPD,

THRD_PTY.PREPR_FIRST_NM as PREPR_FIRST_NM,

THRD_PTY.PREPR_LAST_NM as PREPR_LAST_NM,

THRD_PTY.ADDR as ADDR,

THRD_PTY.CITY as CITY,

THRD_PTY.STT_PROVN as STT_PROVN,

THRD_PTY.PHN_NO as PHN_NO,

THRD_PTY.THRD_PTY_LD_FL_NM as THRD_PTY_LD_FL_NM,

THRD_PTY.CK_SUM_NO as CK_SUM_NO,

THRD_PTY.CMPND_CD as CMPND_CD,

THRD_PTY.EML as EML,

THRD_PTY.YR_MJRTY_ACT_CMPLTD as YR_MJRTY_ACT_CMPLTD,

THRD_PTY.CALN_MO_YR_DATA_SUBN as CALN_MO_YR_DATA_SUBN,

THRD_PTY.THRPUTC_CD as THRPUTC_CD,

THRD_PTY.PROTCL_NO as PROTCL_NO,

THRD_PTY.FMV_LOW as FMV_LOW,

THRD_PTY.FMV_HGH as FMV_HGH,

THRD_PTY.PGM_NM as PGM_NM,

THRD_PTY.PGM_STRT_DT as PGM_STRT_DT,

THRD_PTY.PGM_END_DT as PGM_END_DT,

THRD_PTY.VENUS_LOC as VENUS_LOC,

THRD_PTY.PGM_STT_PROVN as PGM_STT_PROVN,

THRD_PTY.TOT_RECS_PRCSSD as TOT_RECS_PRCSSD,

THRD_PTY.TOT_RECS_ACPTD as TOT_RECS_ACPTD,

THRD_PTY.TOT_RECS_REJD as TOT_RECS_REJD,

THRD_PTY.ROW_ADD_TMS as ROW_ADD_TMS,

THRD_PTY.ROW_ADD_EML as ROW_ADD_EML,

THRD_PTY.ROW_ADD_WHO as ROW_ADD_WHO,

THRD_PTY.ROW_UPD_TMS as ROW_UPD_TMS,

THRD_PTY.ROW_UPD_EML as ROW_UPD_EML,

THRD_PTY.ROW_UPD_WHO as ROW_UPD_WHO,

THRD_PTY.THRD_PTY_LD_FL_SZ as THRD_PTY_LD_FL_SZ,

THRD_PTY.DOC_SEQ_NO as DOC_SEQ_NO,

THRD_PTY.SUPLR_NO as SUPLR_NO,

THRD_PTY.SUPLR_SUFX_NO as SUPLR_SUFX_NO,

THRD_PTY.TOTL_REC_PRCSSD as TOTL_REC_PRCSSD,

THRD_PTY.TOTL_REC_UPLD as TOTL_REC_UPLD,

THRD_PTY.ERR_FILE_SENT_DT as ERR_FILE_SENT_DT,

THRD_PTY.SENT_TO_EMAIL_ADDR as SENT_TO_EMAIL_ADDR,

THRD_PTY.ERR_REC_CNT as ERR_REC_CNT,

THRD_PTY.ERR_FL_NM as ERR_FL_NM,

THRD_PTY.LOG_FL_NM as LOG_FL_NM,

THRD_PTY.LOG_FL_SZ as LOG_FL_SZ,

THRD_PTY.LOG_FL_UPD_DT as LOG_FL_UPD_DT,

THRD_PTY.ERR_FL_SZ as ERR_FL_SZ,

THRD_PTY.FILE_ID as FILE_ID,

THRD_PTY.ETL_PRCSS_START_DT as ETL_PRCSS_START_DT,

THRD_PTY.ETL_PRCSS_END_DT as ETL_PRCSS_END_DT,

THRD_PTY.ETL_PRCSS_STAT_CD as ETL_PRCSS_STAT_CD,

THRD_PTY.ETL_PRCSS_ERR_CD as ETL_PRCSS_ERR_CD,

THRD_PTY.ATTEST_IND as ATTEST_IND,

THRD_PTY.ETL_PRCSS_IND as ETL_PRCSS_IND,

THRD_PTY.SUPLR_TRACK_IND as SUPLR_TRACK_IND,

THRD_PTY.THRD_PTY_ATTEST_TMS as THRD_PTY_ATTEST_TMS,

THRD_PTY.INT_UPLOAD_IND as INT_UPLOAD_IND,

THRD_PTY.EXT_UPLOAD_IND as EXT_UPLOAD_IND,

THRD_PTY.ATTEST_DATA as ATTEST_DATA,

THRD_PTY.TOT_RECS_DLTD as TOT_RECS_DLTD,

THRD_PTY.THRD_PTY_ATTEST_DATA_TMS as THRD_PTY_ATTEST_DATA_TMS,

THRD_PTY.MULT_MO_DATA_SUBN as MULT_MO_DATA_SUBN,

THRD_PTY.ATTEST_IND_EML as ATTEST_IND_EML,

THRD_PTY.ATTEST_IND_WWID as ATTEST_IND_WWID

from

JJCUS_HCC_Totality..TOT_READ_ONLY.CLS_OUT_RPT_REQUEST_DTL CLS_OUT_RPT_REQUEST_DTL,

JJCUS_HCC_Totality..TOT_READ_ONLY.THRD_PTY THRD_PTY

where

(((CLS_OUT_RPT_REQUEST_DTL.PO_NO = THRD_PTY.PO_NO)

or (CLS_OUT_RPT_REQUEST_DTL.CK_REQSTN_NO = THRD_PTY.CK_REQSTN_NO))

or (CLS_OUT_RPT_REQUEST_DTL.TOTALITY_ID = THRD_PTY.TOTALITY_ID))

topic Implement OR condition in qlikview for 3 fields in QlikView

Implement OR condition in qlikview for 3 fields