topic Re: Creating QVD file from multiple data sources in QlikView

Creating QVD file from multiple data sources

Anonymous — Tue, 03 May 2016 15:29:05 GMT

Is it possible to create QVD by joining Table 1 from Oracle and Table 2 from sql server or any other data source?If it is p[possible please share the syntax

Re: Creating QVD file from multiple data sources

richard_chilvers — Tue, 03 May 2016 15:46:03 GMT

The STORE command for creating a QVD file relies on your data all being in a single table.

But QlikView is happy for you to create that table from 2 or more different sources using the appropriate JOIN command.

Re: Creating QVD file from multiple data sources

Anonymous — Tue, 03 May 2016 15:54:43 GMT

This is what I am trying to do.I want to create a single qvd file by joining amazon table and oracle table

LET vQVDName = 'Concept_Map';

// CONNECT TO AMAZON DATA SOURCE

$(Include=..\scripts\amazonrs.qvs);

$(vQVDName):

LOAD

column1

;

Select column1 from rsdatabase ;

// CONNECT TO ORACLE DATA SOURCE

$(Include=..\scripts\oracle.qvs);

LEFT JOIN ($(vQVDName))

LOAD *;

Select column1,column2,column3 from oracledatabase ;

// STORE TABLE INTO QVD FILE

STORE $(vQVDName) INTO $(vQVDName).QVD (QVD);

DROP TABLES $(vQVDName);

DISCONNECT;

Re: Creating QVD file from multiple data sources

MindaugasBacius — Tue, 03 May 2016 16:04:32 GMT

You can make any joins and/or make any aggregations it's up to you.

Basically you can store data into QVD file when ever you wish.

The syntax is simple:

STORE "tablename" INTO "path where you want to save the QVD and under what name";

For example:

STORE invoice INTO E:\Documents\Invoice.qvd;

Re: Creating QVD file from multiple data sources

Anonymous — Tue, 03 May 2016 16:19:23 GMT

Thanks for your reply but my actual question was can we create a QVD by joining two tables from different data sources (i.e one table from oracle and other table from amazon redshift and creating a qvd)