topic Re: split QVD to CSVs in QlikView

split QVD to CSVs

shahafei2 — Sun, 09 May 2021 10:34:15 GMT

Hi,

I have a huge QVD file that I would like to split equally between X CSV files

Any idea how can I do it if the amount of records doesn't know?

Re: split QVD to CSVs

Taoufiq_Zarra — Sun, 09 May 2021 11:08:17 GMT

@shahafei2 if you have a rowno() or keyID in you datasource you can use the script below, if not you have to add it in your qvd file before the script like ;

Data:

LOAD

RowNo() AS RowNum,

FROM DataSource;

to know the no of records in your QVD you can use QvdNoOfRecords ('Data.qvd')

suppose you want to plit the qvd to 10 csv file,the scipt :

LET vRowsPerFile = QvdNoOfRecords ('Data.qvd')/10; LET vRowCount =QvdNoOfRecords ('Data.qvd'); LET vNoOfPages = Ceil(vRowCount/vRowsPerFile); LET vRowStartNum = 1; For Index = 1 to vNoOfPages LET vRowEndNum = vRowsPerFile * Index; Temp: NoConcatenate LOAD * RESIDENT Data WHERE RowNum >= $(vRowStartNum) AND RowNum <=$(vRowEndNum); STORE Temp INTO File$(Index).qvd;

Re: split QVD to CSVs

shahafei2 — Mon, 10 May 2021 09:40:51 GMT

Thanks ill try it

Re: split QVD to CSVs

shahafei2 — Sun, 16 May 2021 07:58:57 GMT

Thanks a lot

it's worked like a magic