Table not found error for store into .qvd

[#1]

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='';

[sunny_talwar]

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

[Clever_Anjos]

Data:

                NOCONCATENATE

                LOAD * ,'$(vName)';

I think you are missing a FROM here

[#4]

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!