topic Re: QVD File loading in App Development

QVD File loading

Uma7 — Fri, 15 Nov 2024 21:46:50 GMT

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);

Re: QVD File loading

Chanty4u — Tue, 23 May 2023 09:43:14 GMT

If you are not doing any transformation you can use

Load *

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;

Re: QVD File loading

Uma7 — Tue, 23 May 2023 09:43:21 GMT

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.

Re: QVD File loading

Chanty4u — Tue, 23 May 2023 09:45:11 GMT

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

Re: QVD File loading

Uma7 — Tue, 23 May 2023 09:49:31 GMT

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

Re: QVD File loading

Chanty4u — Tue, 23 May 2023 09:55:02 GMT

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 ;