3 Replies Latest reply: Oct 1, 2015 8:06 AM by Thomas Chovanec RSS

    LOAD ISSUE

    Mayuri Nandu

      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 :

       

      PY_MATERIAL_TRANSACTIONS1:

       

      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;