Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can someone please help what is wrong here
The script has noting to filter data from TEMP_Symbol_DAY.QVD . Can you attach a sample file ?