topic Re: Two tables and one QVD in QlikView

Two tables and one QVD

Thu, 27 Nov 2014 09:40:45 GMT

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

Re: Two tables and one QVD

agomes1971 — Thu, 27 Nov 2014 09:46:32 GMT

Hi,

see this...

Incremental Load in QlikView – Part1 | Learn QlikView

Hope it helps

Regards

André Gomes

Re: Two tables and one QVD

Anonymous — Thu, 27 Nov 2014 09:48:59 GMT

Only if you concatenate the two tables

Both:

noconcatenate Load ...

resident Android

concatenate (Both) load

resident IOS

store Both to Both.qvd

Re: Two tables and one QVD

its_anandrjs — Thu, 27 Nov 2014 09:53:47 GMT

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

Re: Two tables and one QVD

amit_saini — Thu, 27 Nov 2014 09:57:37 GMT

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,

Re: Two tables and one QVD

ychaitanya — Thu, 27 Nov 2014 10:01:09 GMT

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