This tutorial shows how to convert a QVD file into CSV format in Advanced ETL Processor. Use the QVD Reader for the source and the Text File Writer for the CSV output, without needing Qlik on the processing machine.
What You Will Learn
- Configure the QVD Reader as the transformation source.
- Read the single table stored inside the QVD file.
- Configure the Text File Writer for CSV output.
- Check delimiters, headers, and numeric fields before scheduling the conversion.
Before You Start
Use a test repository or safe sample data while following the tutorial. Production jobs are a poor place to experiment.
QVD Reader And CSV Writer Docs
This tutorial uses the QVD Reader to read the Qlik data file and the Text File Writer to create the CSV output. It is a direct file conversion: read the QVD table, map the fields, write a delimited file. Very civilised, assuming nobody changes the delimiter on Friday afternoon.
The QVD Reader documentation explains what QVD files contain, the reader properties, and the Ignore format option for numeric fields that might otherwise be interpreted as dates or timestamps.
The Text File Writer documentation covers writer properties, the data definition view, field name formatting, and header and footer settings. For CSV work, check delimiter, text qualifier, header row, encoding, and output file name before running the conversion unattended.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.