topic Re: Left join + Load * resident throws error in QlikView

Left join + Load * resident throws error

Qlikandlearn — Sat, 16 Nov 2024 00:26:57 GMT

HI, I'm trying to execute this script in Qlikview

1. from 1st tab :

Req:
LOAD Source as Cube,
Source&'-'&DIMID&'.QVD' as QvdFile,
DIMID,
RECORDS,
Color,
StatusText
FROM
[..\Data Refresh Time\CO_Actual_Record_Counts.qvd](qvd)
where [End Time] > MonthStart(Today()-500);

Trace ----------------------------------------;

2. From 2nd tab:

Sub GetQvdFiles(FilePath);
For each File in filelist ('$(FilePath)');
Files:
Load
'$(File)' as FileName,
Mid('$(File)',Index('$(File)','\',-1)+1,len('$(File)')-Index('$(File)','\',-1)) as QvdFile,
FileSize( '$(File)' ) as Size,
FileTime( '$(File)' ) as FileTime
autogenerate 1;
NEXT;

left join(Req)
Load * Resident Files;
Drop Table Files;

ENDSUB;

when I'm reloading the script, it throws an error like "Table Files not found", any thoughts???

Thanks.

Re: Left join + Load * resident throws error

fosuzuki — Sun, 21 Jun 2020 14:58:14 GMT

Hi,

Does your script have more code?

Can you post the reload log?

Re: Left join + Load * resident throws error

Qlikandlearn — Sun, 21 Jun 2020 16:44:17 GMT

Thanks for your response.

The script is failing as it's throwing an error as "Table Files not found left join(Req)
Load * Resident Files;
Drop Table Files;".

Do I need to add or change any to the script?

When I comment the below three lines, it's working, but the qvd's it creates may not have accurate data

left join(Req)
Load * Resident Files;
Drop Table Files;

Re: Left join + Load * resident throws error

Qlikandlearn — Sun, 21 Jun 2020 17:11:19 GMT

Please find the script what I have from 2 different tabs from Edit script..

Sub GetRequests;

Trace ----------------------------------------;
Trace Load requests;
//Req:
//Load '$(Cube)' as Cube,
// '$(Cube)-'&DIMID&'.QVD' as QvdFile,
// *;
//Select DIMID,
// SID_0REQUID
//From /BIC/D$(Cube)P;

Trace ----------------------------------------;
ENDSUB;

Thanks in advance..

Re: Left join + Load * resident throws error

fosuzuki — Mon, 22 Jun 2020 07:33:11 GMT

The reload log would probably tell us what is going on, but it is hard to help you if you don't help us...

A wild guess is that the SUB is called with a FilePath which doesn't have any files.

Re: Left join + Load * resident throws error

Brett_Bleess — Wed, 08 Jul 2020 18:05:32 GMT

See the following Article link on how to enable Script/Document logging:

Enable Script/Document Logging

Regards,
Brett

Re: Left join + Load * resident throws error

Qlikandlearn — Mon, 21 Sep 2020 13:02:53 GMT

Thanks for your responses, this issue has resolved.

Re: Left join + Load * resident throws error

Brett_Bleess — Tue, 22 Sep 2020 12:23:31 GMT

We would appreciate it if you would properly close out the thread by using the Accept as Solution button on the post(s) that helped you resolve the issue, or if you figured out something different, please post what you did and then mark that as the solution so others will know what the issue was and what you did to address it.

Regards,
Brett