topic Re: Creating new QVD on each reload in App Development

Creating new QVD on each reload

priyasawant — Thu, 12 Nov 2020 12:15:30 GMT

Hi,

I have a data set connection want different QVD to create after each reload.

For e.g,

Tab:

Load *,

From $(vpath);

store Tab into $(vstorepath);

After each reload I should get a new QVD as QVD_1,QVD_2,QVD_3,QVD_4 and so on

Output in the Folder should look like,

QVD_1.qvd

QVD_2.qvd

QVD_3.qvd

QVD_4.qvd

and so on......

Re: Creating new QVD on each reload

MayilVahanan — Thu, 12 Nov 2020 12:38:14 GMT

Hi @priyasawant

Try like below

If QvdCreateTime('T_*.qvd') then
Let vRow = 1;

else
Let vRow = if($(vNextRow) = 0, 1, $(vNextRow));
ENDIF;

T:
Load * from yoursource;

store T into T_$(vRow).qvd(qvd);

Let vNextRow = $(vRow) +1;

Change the table and qvd name based on ur datamodel.

Re: Creating new QVD on each reload

priyasawant — Fri, 13 Nov 2020 09:21:08 GMT

@MayilVahanan

Thank you so much for the response.

i am getting error while loading the below...

else
Let vRow = if($(vNextRow) = 0, 1, $(vNextRow));
ENDIF;

Re: Creating new QVD on each reload

MayilVahanan — Fri, 13 Nov 2020 09:28:56 GMT

Hi @priyasawant

Do you have the qvd already?
In that case, it throws error for first time.
Either delete the qvd in the folder or ignore the error for the first time.

Re: Creating new QVD on each reload

priyasawant — Fri, 13 Nov 2020 09:40:31 GMT

Unexpected token error