Two tables and one QVD

[#1]

Hi All,

I have two tables by name  ANDROID and iOS , i want to make one QVD for both the files , how do i do that

thanks in advance

[agomes1971]

Hi,

see this...

Incremental Load in QlikView – Part1 | Learn QlikView

Hope it helps

Regards

André Gomes

[Anonymous]

Only if you concatenate the two tables

Both:

noconcatenate Load ...

resident Android

concatenate (Both) load

..

resident IOS

store Both to Both.qvd

[its_anandrjs]

Hi,

By the help of Common QVD creation you can do this like

ANDROID:

Load *
From Android;

iOS:

Load *
From iOS;

Noconcatenate

CommonQvd:

Load *

Resident Android;

Concatenate(CommonQvd)

Load *
Resident iOS;

Store CommonQvd into CommonQvd.qvd;

Regards,

Anand

[amit_saini]

I got this solution on community , try if this helps u:

You can store in QVD files using like this

STORE Table1 INTO Table1.qvd;

STORE Table2 INTO Table2.qvd;

STORE Table3 INTO Table3.qvd;

'

'

'

'

STORE Tablen INTO Tablen.qvd;

Or you can use For loop to store all tables in QVDs like below

FOR vCount = 0 to NoOfTables()-1

     LET vTableName = TableName($(vCount));

     STORE $(vTableName ) INTO $(vTableName).qvd (qvd);

NEXT vCount

Thanks,

AS

[ychaitanya]

From your queestion i understand:

1) We can't write the different tables into same QVD.( Latest Table data will be written to QVD will replacing the older table data)

I have just tried with the following example:

You can comment store commands and observe the difference.

LOAD * INLINE [

    A

    1

    2

    3

];



Store Tab1 into C:\user\Tab1.qvd;



Tab2:

LOAD * INLINE [

    B

    1

    2

    3

];

Store Tab2 into C:\user\Tab1.qvd;

IF YOU WANT TO ACHIEVE THIS:

1)You can concatenate/Join the tabled and load to QVD.

2)Outer join/Left Join/Right Join might help if you have the common column .

3) Concatenate both the tables.

Thanks

Chaitanya Y