topic Re: How many QVDs create?? in QlikView

How many QVDs create??

Mon, 15 Dec 2014 06:44:19 GMT

I'm joining two tables, please let me know how many QVD files create, ethier 1 or 2, below is details?

OthersStaff:

LOAD

EMPID AS CODE,

AG_NAME AS NAME,

AG_BRCODE AS BRANCH,

AG_DESIG AS DESIGNATION;

SQL SELECT *

FROM "TR_RECRUIT"."ATTEND_OTHERS";

Inner Join //--------------- Joining ------------------------//

Attendance:

LOAD

AAG_AGCODE AS CODE,

AAG_BRCODE AS BRANCH,

AAG_ATTNTIME AS TIME,

Date(INPUT_DATE,'DD-MMM') AS DATE,

STATUS;

SQL SELECT *

FROM ATTEND_REG;

Store OthersStaff into C:\Users\Naveed_Shahzad\Desktop\QlikView\Mydata.qvd;??

Regards,

Naveed

Re: How many QVDs create??

its_anandrjs — Mon, 15 Dec 2014 06:49:37 GMT

It seems one QVD named Mydata.qvd

Regards

Anand

Re: How many QVDs create??

ashfaq_haseeb — Mon, 15 Dec 2014 06:54:08 GMT

HI, you will get 1 table

Check this for more info on joins

http://community.qlik.com/docs/DOC-6562

http://community.qlik.com/thread/39177

http://community.qlik.com/thread/134760

Regards

ASHFAQ

Re: How many QVDs create??

rajeshvaswani77 — Mon, 15 Dec 2014 07:00:14 GMT

Ideally create 1 QVD for each table.

hanks,

Rajesh Vaswani

Re: How many QVDs create??

its_anandrjs — Mon, 15 Dec 2014 07:08:00 GMT

Hi,

After loading this table with Inner join you get single table and by using the Store command you get single table storing

OthersStaff:

LOAD

EMPID AS CODE,

AG_NAME AS NAME,

AG_BRCODE AS BRANCH,

AG_DESIG AS DESIGNATION;

SQL SELECT *

FROM "TR_RECRUIT"."ATTEND_OTHERS";

Inner Join //--------------- Joining ------------------------//

Attendance:

LOAD

AAG_AGCODE AS CODE,

AAG_BRCODE AS BRANCH,

AAG_ATTNTIME AS TIME,

Date(INPUT_DATE,'DD-MMM') AS DATE,

STATUS;

SQL SELECT *

FROM ATTEND_REG;

Store OthersStaff into C:\Users\Naveed_Shahzad\Desktop\QlikView\Mydata.qvd;

You Get QVd with named Mydata.qvd in the folder location C:\Users\Naveed_Shahzad\Desktop\QlikView\

Hope this helps

Regards

Anand

Re: How many QVDs create??

Mon, 15 Dec 2014 07:15:43 GMT

hi,

Only One qvd

Mydata.qvd

sudhanshu shrivas

Re: How many QVDs create??

Mon, 15 Dec 2014 07:18:39 GMT

Hi,

Once you join the table, it will create only one QVD.

Re: How many QVDs create??

Mon, 15 Dec 2014 07:23:36 GMT

Thank you very much its very usefull.

Regards,

Naveed

Re: How many QVDs create??

ashfaq_haseeb — Mon, 15 Dec 2014 07:28:36 GMT

Hi,

Please close the thread by selecting appropriate answers.

Regards

ASHFAQ