How many QVDs create??

[#1]

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

[its_anandrjs]

It seems one QVD named Mydata.qvd

Regards

Anand

[ashfaq_haseeb]

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

[rajeshvaswani77]

Ideally create 1 QVD for each table.

hanks,

Rajesh Vaswani

[its_anandrjs]

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

[#6]

hi,

Only One qvd

Mydata.qvd

sudhanshu shrivas

[#7]

Hi,

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

[#8]

Thank you very much its very usefull.

Regards,

Naveed

[ashfaq_haseeb · Accepted solution]

Hi,

Please close the thread by selecting appropriate answers.

Regards

ASHFAQ