Creating QVD file from multiple data sources

[Anonymous]

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

[richard_chilvers]

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.

[Anonymous]

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;

[MindaugasBacius]

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;

[Anonymous]

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)