topic Re: Resident table not found in QlikView

Resident table not found

k_burata — Fri, 08 Dec 2017 02:42:17 GMT

Hi Guys,

Been running this script below but it always tells me that table not found. This works on my Dev environment but when I Reload on Prod error comes out. Seems easy though.

cheers,

"Purchase Orders":

LOAD [PO Cost Centre],

[PO Company ID] AS [Company ID],

[PO Account ID],

[PO Order No],

[PO Order Line],

[PO Release No],

[PO Currency Code],

[PO Part No],

[PO Pre Accounting ID],

[PO Amount Balance],

[PO Created Date],

[PO Part Description],

[PO Amount Balance 3rd],

[PO Quantity Balance],

[PO Accounting Period],

[PO Accounting Year],

[PO Date],

[PO Wanted Delivery Date],

[PO Reference Link]

FROM

[..\QvData\Transform\IFS\QVD\Purchase Order VM.qvd]

(qvd);

NoConcatenate

MinMaxOpenPODate:

Load

min([PO Wanted Delivery Date]) as MinDatePO,

max([PO Wanted Delivery Date]) as MaxDatePO

RESIDENT "Purchase Orders";

Re: Resident table not found

Anil_Babu_Samineni — Fri, 08 Dec 2017 02:44:23 GMT

Can you change your directory from " " to [ ] ... Even with Resident as well

Re: Resident table not found

k_burata — Fri, 08 Dec 2017 02:49:21 GMT

You mean to this?

[Purchase Orders]:

LOAD [PO Cost Centre],

[PO Company ID] AS [Company ID],

[PO Account ID],

[PO Order No],

[PO Order Line],

[PO Release No],

[PO Currency Code],

[PO Part No],

[PO Pre Accounting ID],

[PO Amount Balance],

[PO Created Date],

[PO Part Description],

[PO Amount Balance 3rd],

[PO Quantity Balance],

[PO Accounting Period],

[PO Accounting Year],

[PO Date],

[PO Wanted Delivery Date],

[PO Reference Link]

FROM

[..\QvData\Transform\IFS\QVD\Purchase Order VM.qvd]

(qvd);

NoConcatenate

MinMaxOpenPODate:

Load

min([PO Wanted Delivery Date]) as MinDatePO,

max([PO Wanted Delivery Date]) as MaxDatePO

RESIDENT [Purchase Orders];

Still same error.

Re: Resident table not found

Anil_Babu_Samineni — Fri, 08 Dec 2017 03:13:12 GMT

Image please? Because, I tested it's working..

Re: Resident table not found

k_burata — Fri, 08 Dec 2017 03:19:15 GMT

Yeah, it's a bit strange because it's working on my Dev.

*I've commented out the tabs on the right of this

Re: Resident table not found

Anil_Babu_Samineni — Fri, 08 Dec 2017 03:43:56 GMT

When you say, It is working for Dev. I believe there is some path issue. But, Path issue come under "File name not allowed" error will up. So, this case Can you give exact path instead root ...

Re: Resident table not found

k_burata — Fri, 08 Dec 2017 03:45:04 GMT

Strange it's working now.

This caused the error. Because we were transferring to a new environment, when I put in the correct values in the variable.txt file it worked right away. Strange though, it doesn't seem to be connected to the error I'm getting. Might be wrong though.

Re: Resident table not found

Anil_Babu_Samineni — Fri, 08 Dec 2017 03:50:19 GMT

Haha.. Good. You can close this thread..