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"