Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

Load database as flat file

Hi,

I'm working with a database which is no longer being updated. The only thing needed is an occational lookup on old static data. I would like to use a basic table listing in qlikview for this, and just keeping the database as a flat file and getting rid of the database. How can I load the entire database into a flat file, and then use this file to add new tables and columns as they are needed later on?

Tags (2)
1 Solution

Accepted Solutions
jsn
Honored Contributor

Re: Load database as flat file

Maybe load the tables and store them as QVD files?

2 Replies
jsn
Honored Contributor

Re: Load database as flat file

Maybe load the tables and store them as QVD files?

Not applicable

Re: Load database as flat file

As the database will be removed, I've exported the tables and views to csv files. A quicker approach than going through each schema and table in QlikView and then storing it av QVD files in my case.

Community Browser