Creating QVD for multiple tables from SQL Server

[#1]

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.

[brenner_martina]

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

[#3]

Danke!

Let me try this.

TA

NYC

[#4]

Why Load statement is important in QV.

Is it used to create new fields?

[jvitantonio]

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;

[brenner_martina]

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

[#7]

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?

[jagan]

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.

[etl_tools]

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