LOAD ISSUE

QlikAngel — Thu, 01 Oct 2015 05:57:32 GMT

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;

Re: LOAD ISSUE

m_woolf — Thu, 01 Oct 2015 12:01:01 GMT

I don't see noconcatenate in your script.

Re: LOAD ISSUE

tchovanec — Thu, 01 Oct 2015 12:05:04 GMT

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

Re: LOAD ISSUE

tchovanec — Thu, 01 Oct 2015 12:06:56 GMT

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

topic Re: LOAD ISSUE in QlikView

LOAD ISSUE

Re: LOAD ISSUE

Re: LOAD ISSUE

Re: LOAD ISSUE