topic Re: Creating QVD for multiple tables from SQL Server in QlikView

Creating QVD for multiple tables from SQL Server

Fri, 07 Sep 2012 10:48:03 GMT

Yesterday I was watching a video on youtube in which guy was saying that QVD can only be created based on one table, is that correct?

If not can I create QVD for mulbitple tables from SQL server?

When I connect QV to SQL Server DB QV script area show me SQL and not the Load at the top of every table.

Why?

What can I do to see the Load instead of SQL.

Re: Creating QVD for multiple tables from SQL Server

brenner_martina — Fri, 07 Sep 2012 11:11:50 GMT

Hi,

at first, yes, a qvd is always created from 1 tabel by

store table1 Into table1.qvd;

store table2 into table2.qvd;

but in QlikView script you can concatente or join tables together and than store that new table in one qvd.

second: you need to mark on right bottom side "show load statement before2 (or similar text).

Greetings from Munich

Martina

Re: Creating QVD for multiple tables from SQL Server

Fri, 07 Sep 2012 13:34:53 GMT

Danke!

Let me try this.

NYC

Re: Creating QVD for multiple tables from SQL Server

Fri, 07 Sep 2012 14:11:50 GMT

Why Load statement is important in QV.

Is it used to create new fields?

Re: Creating QVD for multiple tables from SQL Server

jvitantonio — Fri, 07 Sep 2012 14:13:43 GMT

Yes. You can create new fields or manipulate the existing ones. For example:

LOAD

month(Date) as Month,

Year(Date) as Year,

Date

;

SQL SELECT Date FROM YourDBTable;

Re: Creating QVD for multiple tables from SQL Server

brenner_martina — Fri, 07 Sep 2012 14:18:22 GMT

Hi, TA,

the load-statement is not necessary, if you do not change anything, but if you create new fields by using functions, you can use the load-statement at same time by loading data from source.

Greetings from Munich

Martina

Re: Creating QVD for multiple tables from SQL Server

Sun, 09 Sep 2012 15:25:55 GMT

I have two CSV files which I want to join and create one qvd:

Here are the names of the tables:

Users

PVLastWeek

How can I concatenate these two tables and create one qvd?

Re: Creating QVD for multiple tables from SQL Server

jagan — Mon, 10 Sep 2012 06:32:29 GMT

Hi,

To Concatenate two tables use the following syntax

TableName:

LOAD

FROM Users;

CONCATENATE

LOAD

FROM PVLastWeek;

If you want to join two tables then use following syntax

TableName:

LOAD

FROM Users;

LEFT JOIN

LOAD

FROM PVLastWeek;

Hope this helps you.

Regards,

Jagan.

Re: Creating QVD for multiple tables from SQL Server

etl_tools — Mon, 10 Sep 2012 09:28:16 GMT

You can now use Advanced ETL Processor (AETL) to load QVD files into the database

http://www.etl-tools.com/articles/datawarehousing/loading-qvd-files-into-the-database.html

AETL works wih 27 datasources and 22 data targers.

Mike