Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
k_burata
Contributor

Resident table not found

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";

1 Solution

Accepted Solutions
Highlighted
k_burata
Contributor

Re: Resident table not found

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.

View solution in original post

7 Replies
Highlighted

Re: Resident table not found

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
k_burata
Contributor

Re: Resident table not found

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.

Highlighted

Re: Resident table not found

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
k_burata
Contributor

Re: Resident table not found

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

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

Highlighted

Re: Resident table not found

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 ...

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
k_burata
Contributor

Re: Resident table not found

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.

View solution in original post

Highlighted

Re: Resident table not found

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)