split the qvd size

[prabhas277]

HI experts,

i have  one Qvd and that size of Qvd is 10 gb. now i need to split that Qvd into 5 small qvds and each size of qvd is 2 gb. how i can convert it?

[Chanty4u]

hi,

chk dis

how to split qvd's dynamically?

splitting single QVD data into 2 QVD's

[sujeetsingh]

Split one big QVD file into multiple

How to split Qvd into saparate partition Qvds in Qlikview?

[settu_periasamy]

Hi Prabhas,

What based you want to Split your qvd's?  May be you can split the QVD based on Year (If you have the Field)

for example, You can Load the Distinct Year, and based on that you can split..

Like

Temp:
LOAD * INLINE [
Year
2010
2011
2012
2013
2014
2015
];

NoConcatenate
T1:
LOAD Distinct Year Resident Temp;
DROP Table Temp;
Let vNoOfRows=NoOfRows('T1');
for i= 1 to vNoOfRows
      Let TabName = FieldValue('Year',$(i));
      NoConcatenate
      $(TabName):
      LOAD Year Resident T1 Where Year=FieldValue('Year',$(i));
      STORE $(TabName) into $(TabName).qvd(qvd);
      DROP Table $(TabName);
Next i

[jagan]

Hi,

On what basis you want to split the QVD?  By Year, Country, Branch etc.  Based on that load the QVD with where conditon and save it.

Regards,

Jagan.

[Anonymous]

Hi,

Splitting qvd will be good when you split on certain criteria like if your qvd data consists of Year's data split it into Monthly data ,if month split it into week etc...

So Make sure on what criteria you are going to split .

[ramasaisaksoft]

Hi Prabhas,

What is your goal to slit qvd into number of qvd's?

1) You can take a copy of the same qvd and then go to Debug-> there you can give 500/1000 records number as per your convenience so that you will get required data  and that to size is less.

2) Filter the QVD data with Country,Year....RSM wise as per your wish.it will also reduce your file size.

[Peter_Cammaert]

I guess the OP wants to split the QVD in equally sized files of 2GB. Apparently, everbody knows that you can split on some kind of dimension, but that may lead to for example the Year=2010 QVD containing 100MB and Year=2015 containing 7GB.

I would also be interested to know how the community solves this challenge: splitting an internal table into QVDs where filesize() returns 2GB (or less but only for the last part)

[PradeepReddy]

We can split the QVD into different files based on dimensions, using 'where' clause in Load statement

but if you want to split the QVD based on size, might be not possible..

If this is possible, how can achieve it?. It is an interesting scenario...