Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
k_burata
Creator
Creator

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
k_burata
Creator
Creator
Author

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
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
k_burata
Creator
Creator
Author

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.

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
k_burata
Creator
Creator
Author

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

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

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
k_burata
Creator
Creator
Author

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.

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)