Would Appreciate help with Joins

Wed, 25 Nov 2020 16:16:04 GMT

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"

topic Would Appreciate help with Joins in QlikView

Would Appreciate help with Joins