Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm new to Qlik, and need help joining the two below tables on 4 fields. CALENDAR_DT, FY_YEAR_NM, FY_MONTH_NUM, CMPGN_TYPE
Any help would be greatly appreciated.
SQL SELECT "ACTUAL_TOTAL_CALLS", "CAL_DAY_OF_WEEK", "CALENDAR_DT", "CMPGN_GRP", "CMPGN_ID", "CMPGN_NM", "FY_DAY_NUM", "FY_MONTH_NM", "FY_MONTH_NUM", "FY_YEAR_NM", "RPT_CMPGN_GRP", "RPT_CMPGN_TYPE" as "CMPGN_TYPE" FROM CHTRPRODRDM."RDM_DM_AC_CALLS_BYDY_VW"; SQL SELECT "CAL_DAY_OF_WEEK", C "CMPGN_TYPE", "FY_DAY_NUM", "FY_MONTH_NM", "FY_MONTH_NUM", "FY_YEAR_NM", "TOTAL_CALLS" FROM CHTRPRODRDM."RDM_DM_BG_CALLS_BYDY_VW"