Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If i load table in resident than values are not coming in chart.. as i remove resident load then values are coming in chart..
Not working after applying noconcatenate .. also data not coming.. & this is happning with all tables which i m loading optimized & taking then in resident..
what will be the issue
CODE IS LIKE BELOW :
LOAD INVENTORY_ITEM_ID,
ORGANIZATION_ID,
TRANSACTION_SOURCE_ID,
TRANSACTION_TYPE_ID,
TRANSACTION_QUANTITY,
TRANSACTION_DATE,
SECONDARY_TRANSACTION_QUANTITY
FROM $(V_TransactionQVDPath)\MMT.qvd (qvd);
PY_MATERIAL_TRANSACTIONS:
LOAD INVENTORY_ITEM_ID&'_'&ORGANIZATION_ID&'_'&TRANSACTION_SOURCE_ID AS [PY_GBH MMT LINK],
INVENTORY_ITEM_ID&'-'& ORGANIZATION_ID as [PY_ITEM CODE KEY],
ORGANIZATION_ID as MTL_ORGANIZATION_ID,
TRANSACTION_TYPE_ID as [PY_TRANSACTION TYPE ID],
TRANSACTION_QUANTITY as [PY_TRANSACTION QUANTITY],
TRANSACTION_DATE AS [PY_TRANSACTION DATE],
Date(TRANSACTION_DATE) as PY_TRANSACTION_DATE,
MONTHNAME(TRANSACTION_DATE) as [PY_TRANSCTION MONTH],
MONTHSTART(TRANSACTION_DATE) as [PY_MONTHSTART TRANSACTION DATE],
MONTHEND(TRANSACTION_DATE) AS [PY_MONTHEND TRANSACTION DATE],
day(TRANSACTION_DATE) as [PY_TRANSCTION DAY],
SECONDARY_TRANSACTION_QUANTITY as [PY_SECONDARY TRANSACTION QUANTITY]
RESIDENT PY_MATERIAL_TRANSACTIONS1;
DROP TABLE PY_MATERIAL_TRANSACTIONS1;
I don't see noconcatenate in your script.
He shouldn't need noconcatenate because the fields are different in the second table.
What does the log look like after you run the script?