Issue : Left Join in qlikview behaving as Inner Join
SCRIPT IN QLIKVIEW :
TEMP_ALL_STOCK_VOLUME_INT: LOAD TRD_DATE&'|'&Symbol as %Jkey , ACCT_MNEMONIC, VOLUME, NOTIONAL FROM [$(vQVDPath)VOLUME_DAY.QVD] (qvd); INNER JOIN (TEMP_ALL_STOCK_VOLUME_INT) LOAD ACCT_MNEMONIC, FLOWTYPE FROM [$(vQVDPath)TEMPFLOW_DAY.QVD] (qvd);
NoConcatenate TEMP_ALL_STOCK_VOLUME: LOAD TRD_DATE&'|'&Symbol as %Jkey , TRD_DATE, Symbol , SECTOR, INDUSTRY, COUNTRY FROM [$(vQVDPath)TEMP_Symbol_DAY.QVD] (qvd); LEFT JOIN (TEMP_ALL_STOCK_VOLUME) LOAD %Jkey , ACCT_MNEMONIC, FLOWTYPE, CITIVOLUME, CITINOTIONAL RESIDENT TEMP_ALL_STOCK_VOLUME_INT;
DROP table TEMP_ALL_STOCK_VOLUME_INT;
ISSUE : Even after doing left join I am unable to get all the symbol from the TEMP_Symbol_DAY.QVD file its just returning the records for which we have value in TEMP_ALL_STOCK_VOLUME_INT