topic Creating table links after import in QlikView

Creating table links after import

Mon, 16 Apr 2012 16:17:34 GMT

Hello fellow Qlikview Users,

i am very attracted by the functionalities of Qlikview. And would like to do some basic analysis using it.Currently i am in the process of trying to import data and making proper table connections. My Question is in this regard, do i have to do all the manipulation of tables (Naming Tables, Naming Fields, joining tables etc.) during the import of the data (execution of the script) ?. Or do i have the option to import all my necessary tables (unconnected via qualify) and then adjust the tables to my needs (i.e. running a second script)? (Reason is that i am often analysing high amount exotic data and therefore have to get a "look" at the data first and transform them into a standard structure before actually processing them. So having do the full import process of the huge data set in case of errors, can be very time consuming)

Thank you for your help

Creating table links after import

Jason_Michaelides — Mon, 16 Apr 2012 16:24:57 GMT

You could look at importing the data using Qualify, then storing it into QVD files for using in subsequent QVWs...?

Creating table links after import

Mon, 16 Apr 2012 16:32:34 GMT

I would agree with Jason. Creating QVD files that contain (typically) individual tables is helpful as you can then re-use the QVD in numerous QVWs without having to reload the data from the database. It also allows you the flexibility to modify the 'table' (QVD) to suit specific needs.

Creating table links after import

Tue, 17 Apr 2012 07:34:02 GMT

That you very much,

sometimes the most simple answer doesn't come into mind