Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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;
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;
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)