topic Re: split the qvd size in QlikView

split the qvd size

prabhas277 — Mon, 22 Feb 2016 05:33:09 GMT

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?

Re: split the qvd size

Chanty4u — Mon, 22 Feb 2016 05:42:37 GMT

hi,

chk dis

how to split qvd's dynamically?

splitting single QVD data into 2 QVD's

Re: split the qvd size

sujeetsingh — Mon, 22 Feb 2016 05:54:11 GMT

Split one big QVD file into multiple

How to split Qvd into saparate partition Qvds in Qlikview?

Re: split the qvd size

settu_periasamy — Mon, 22 Feb 2016 05:57:39 GMT

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..

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

Re: split the qvd size

jagan — Mon, 22 Feb 2016 06:01:04 GMT

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.

Re: split the qvd size

Anonymous — Mon, 22 Feb 2016 06:10:53 GMT

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 .

Re: split the qvd size

ramasaisaksoft — Mon, 22 Feb 2016 06:27:45 GMT

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.

Re: split the qvd size

Peter_Cammaert — Mon, 22 Feb 2016 07:46:08 GMT

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)

Re: split the qvd size

PradeepReddy — Mon, 22 Feb 2016 07:51:56 GMT

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...