topic Re: Table not found error for store into .qvd in QlikView

Table not found error for store into .qvd

Wed, 25 Nov 2020 16:16:04 GMT

Hi!

New to QV and need some help. Can someone explain why the error message "Table not found" for declared table Data (below in code) shows? Also please give some background reason why this happening, not just how to solve it. Manny thanks!

Latest:

LOAD [File Path],Max([File Time]) as [Max Time] Resident Files Group By [File Path];

Left Join(Latest)

LOAD [File Time] as [Max Time],[File Name] Resident Files;

DROP Table Files;

DROP Table Latest;

LET vName = '$(File)';

let vVal = SubField('$(vName)','\','8');

set vB = $(vVal);

LET vCombine=vQVD&vVal;

set vB = $(vCombine);

Data:

NOCONCATENATE

LOAD * ,'$(vName)'; // as [Src File] From '$(vName)';

STORE Data INTO [$(vQVD).qvd](qvd);drop Table Data; //* from

let vName='';

Re: Table not found error for store into .qvd

sunny_talwar — Thu, 04 Aug 2016 17:58:12 GMT

I don't understand the point of creating Latest when you are not even using it. Or are you using it to create the variable vName? If you are then why are you dropping Latest before the variable is even created?

Latest:

LOAD [File Path],Max([File Time]) as [Max Time] Resident Files Group By [File Path];

Left Join(Latest)

LOAD [File Time] as [Max Time],[File Name] Resident Files;

DROP Table Files;

DROP Table Latest;

LET vName = '$(File)';

I guess it would be easier to help if you share the complete script and not just part of it

Best,

Sunny

Re: Table not found error for store into .qvd

Clever_Anjos — Thu, 04 Aug 2016 18:02:26 GMT

Data:

NOCONCATENATE

LOAD * ,'$(vName)';

I think you are missing a FROM here

Re: Table not found error for store into .qvd

Fri, 05 Aug 2016 06:27:07 GMT

As I mention in the beginning I am verry new to QV. But I solved it. I just use table Latest and removed table data. Thanks for all your replies!