QVD File loading

[Uma7]

Hi All,
i tried loading data from tables to create qvd and fetch back qvd to create sheets.but table not found error is thrown.Can someone help why is it happening and how to resolve it?

Table3:

LOAD "VKORG" as "SalesOrg", 

"Failed", 

"Success", 

"Total",                                

"Failure_Percentage", 

"Region";

[db1]:

SELECT VKORG,

Failed,

Success,

Total,

`Failure_Percentage`,

Region                                           

FROM `cq`.ea.`db1`;

Store Table3 into ['lib://Folder/TestData1.Qvd'];

LOAD SalesOrg,

Failed,

     Success,                                       

     Total,

     Failure_Percentage,

     Region

FROM [lib:/Folder/TestData1.Qvd]

(qvd);

[Chanty4u · Accepted solution]

Hi

If you are not doing any transformation you can use

Load *

Or

Select *

And i can see in db code some unwanted symbols pls remove that and try 

`Failure_Percentage`,

Region                                           

FROM `cq`.ea.`db1`;

Sql  select *  from

cq.ea.db1;

[Uma7]

But i need to rename one column and select it so i can't use LOAD * right?
db code symbols error thanks for that identification.

[Chanty4u]

Rename you can do in main qvf after loading qvd you can modify your fields . First test the things is it creating qvd or not 

[Uma7]

Thank you,

so how can i rename in qvf if its created can you suggest that so i can learn 
i  commented the 1st code block of loading table3 and i was able to create qvd 

[Chanty4u]

Great.

You can load the main qvd and do like this 

Table3:

LOAD "VKORG" as "SalesOrg", 

"Failed", 

"Success", 

"Total",                                

"Failure_Percentage", 

"Region"

From yourmain qvd ;