Can any one please explain how to store two QVDs into one QVD

[#1]

Can any one please explain how to store two QVDs( i already created) into one QVD, i have common column, can any oe give me the syntax.

Thanks

[#2]

Hi,

You could try someting like what you see on this example:

OfficeLocations:
LOAD Country,  //Common Field
Region,
City,
[Business Unit],
[Office Name],
Suma
FROM
Offices.qvd
(qvd);

Left Join

LOAD Country, //Common Field
[Official Long Form],
[ISO Code],
[ISO Short],
[ISO Long],
[UN Code],
[Capital/Major City]
FROM
ISOMaps.qvd
(qvd);

STORE OfficeLocations into OfficeLocations.qvd (qvd);

Hope it helps!

[Marcio_Campestrini]

Hi!

According the case you can use Concatenate:

[aa]:

Load * From a.qvd;

Concatenate

Load * From b.qvd;

Store aa Into aa.qvd.

Hope it helps.

Márcio.

[SunilChauhan]

if you have common columns then you need to identify

the master and transaction table

for example

Emp table and Emp detail

then

emp table

left join

Emp Details.

and if totally diffrent  field/columns

you could combile

emp table

concatenate

inventory table

hope this helps

[#5]

Load * , 1 as flag From a.qvd;

Concatenate

Load * , 2 as flag From b.qvd;

So when you need to get data from 'a' QVD , you can use flag filter .

[aveeeeeee7en]

Depending upon your requirement join 2 Tables:

1) You can use Concatenate() Function between two tables:

ABC:

Load

Name,

Place,

Area,

'ABC' AS FLAG

FROM TABLE1

CONCATENATE(ABC)

XYZ:

Load

Name,

Place,

Area,

'XYZ' AS FLAG

FROM TABLE2

STORE ABC Into C:\.......\Table_Name_You_Want_to_Use.qvd(qvd);

2) You can use Left join based on your Primary Key:

ABC:

Load

Name, // Primary Key

Place,

Area,

FROM TABLE1

Left Join

XYZ:

Load

Name,  // Primary Key

Place AS Place_XYZ,

Area AS Area_XYZ

FROM TABLE2

STORE ABC Into C:\.......\Table_Name_You_Want_to_Use.qvd(qvd);

Regards

Aviral Nag

[#7]

Hello Jose,

Thanks for the quick response

I tried it, but my system hanged

[SunilChauhan]

try loading using

distinct after each load in script

[sibideepak]

Hi,

what is the purpose of storing multiple Qvds into a single qvd ??

[#10]

Joins can be very costly on the machine's resources.

You could try unsing Mapping Load instead. It's a lot faster and taxes resources a lot less. In order to use this function you whould have to create as many mappings as fields you want to add to the resulting table.

Take a look at this example of mapping load:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/13/mapping-and-not-the-geographical-kind