Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
mayuridg
Contributor

LOAD ISSUE

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;

3 Replies
mwoolf
Honored Contributor II

Re: LOAD ISSUE

I don't see noconcatenate in your script.

tchovanec
Contributor

Re: LOAD ISSUE

He shouldn't need noconcatenate because the fields are different in the second table.

tchovanec
Contributor

Re: LOAD ISSUE

What does the log look like after you run the script?

Community Browser