topic Re: How to create multiple QVD from one table. in QlikView

How to create multiple QVD from one table.

debabrata_sahoo — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone. I have some requirement, Please help me out.

From one table I need to create 12 qvds monthly basis. Then one more requirement , When I load these qvds only updated month qvds will load instead of all qvd load.

Thanks,

Deb

Re: How to create multiple QVD from one table.

vikasmahajan — Wed, 31 Oct 2018 05:36:37 GMT

You can specify the condition where while creating QVD in QVD generator , Please post some sample to give

resolution.

regards

Vikas

Re: How to create multiple QVD from one table.

thannila — Wed, 31 Oct 2018 05:36:47 GMT

Yeah you can do that by giving the date directly.

For example - 01-01-2018 to 31-01-2018

similarly for every month

Re: How to create multiple QVD from one table.

Anonymous — Wed, 31 Oct 2018 05:40:11 GMT

Hi,

Perhaps on every STORE statement, you should have a unique identifier.

Something like STORE <table> into <Dir>/<table>_<date or number> . This should be incremental. I would prefer to use date so that when you write a load statement, you can use the name of the latest qvd that you want. The identifier can be stored as a variable to make things a bit easier

Re: How to create multiple QVD from one table.

nasirsaikh — Wed, 31 Oct 2018 05:43:08 GMT

Hi debabrata.sahoo

Please follow the below script..

GetUniqueCode:

NoConcatenate

Load Distinct [YourCode] as Your_Code

From ABC;

Drop Table ABC;

For vRow = 1 to NoOfRows('GetUniqueCode')

Let MyVar = Peek('Your_Code',vRow-1,'GetUniqueCode');

Set TableName = '$(MyVar)';

EXPORT_TABLE:

Load

Column1,

Column2,

Column3,

Column4

FROM YourPathandTableName Where YourCode = '$(TableName)';

Store EXPORT_TABLE into YourPath\Exporting_Table_$(TableName).qvd](qvd);

Drop Table EXPORT_TABLE;

Set MyVar = Null();

Set TableName = Null();

Drop Table GetUniqueCode;

Re: How to create multiple QVD from one table.

nasirsaikh — Wed, 31 Oct 2018 05:47:50 GMT

Please follow the below script..

GetUniqueCode:

NoConcatenate

Load Distinct [YourCode] as Your_Code

From ABC;

Drop Table ABC;

For vRow = 1 to NoOfRows('GetUniqueCode')

Let MyVar = Peek('Your_Code',vRow-1,'GetUniqueCode');

Set TableName = '$(MyVar)';

EXPORT_TABLE:

Load

Column1,

Column2,

Column3,

Column4

FROM YourPathandTableName Where YourCode = '$(TableName)';

Store EXPORT_TABLE into YourPath\Exporting_Table_$(TableName).qvd](qvd);

Drop Table EXPORT_TABLE;

Set MyVar = Null();

Set TableName = Null();

Drop Table GetUniqueCode;

Re: How to create multiple QVD from one table.

tomasz_tru — Wed, 31 Oct 2018 06:12:42 GMT

You can use this subroutine: Subroutines in load script

Readability will be high, and minimum code modification needed.

Tomasz