how to perform join operation on particular field in qlikview

[bvssudhakar]

Hi Experts,

I have two sheets in one excel with multiple common columns. but i want to perform the join operation on one particular column can you please explain me how to do that here i am posting my sample script.

Here, I want to perform join operation by using release column

TestingEfforts:

LOAD Quarter as qtr,

     Year ,

     Month ,

     Client ,

     [Account Manager] ,

     Project ,

     Release,

     [Release Dt],

     [Total Month wise SIT Defects],

     [Total monthwise Internal Defects],

     [Total release wise SIT Defects],

     [Total release wise UAT Defects],

     [Efforts in Hours],

     [Release Status]

FROM

TestingEfoorts.qvd

(qvd);

DefectList:

LOAD Quarter,

     Client,

     [Account Manager],

     [Project Name],

     Release,

     Month,

     Year,

     Id,

     Description,

     [Date Identified],

     [Root Causes/Reason Code],

     [Defect Type],

     [No.of Iterations],

     [Phase Injected]

FROM

DefectList.qvd

(qvd);

Thank you in advance

B V S Sudhakar

[cmorri1988]

possibly this,

-----------------

TestingEfforts:
LOAD Quarter as qtr, 
     Year , 
     Month , 
     Client , 
     [Account Manager] , 
     Project , 
     Release, 
     [Release Dt], 
     [Total Month wise SIT Defects], 
     [Total monthwise Internal Defects], 
     [Total release wise SIT Defects], 
     [Total release wise UAT Defects], 
     [Efforts in Hours], 
     [Release Status]
FROM
TestingEfoorts.qvd
(qvd);

DefectList:

left join(TestingEfforts)
LOAD //Quarter, 
     //Client, 
     //[Account Manager], 
     //[Project Name], 
     Release, 
     //Month, 
     //Year, 
     Id, 
     Description, 
     [Date Identified], 
     [Root Causes/Reason Code], 
     [Defect Type], 
     [No.of Iterations], 
     [Phase Injected]
FROM
DefectList.qvd
(qvd);

[shwethaa]

Keep column name same in both the table on which column it should join. Rename the remaining column names in one of the table . Qlikview join only based on name of the column.

[bvssudhakar]

Hi Morrison,

I want to perform inner join only

[bvssudhakar]

Hi Morrison,

I want to perform inner join only. If i perform that operation i am getting wrong values

can you please check for that

[raman_rastogi]

You can use above discuses approaches.

Or you can try qualify and unqualify

TestingEfforts:

LOAD Quarter as qtr,

     Year ,

     Month ,

     Client ,

     [Account Manager] ,

    [Project Name],

     Release,

     [Release Dt],

     [Total Month wise SIT Defects],

     [Total monthwise Internal Defects],

     [Total release wise SIT Defects],

     [Total release wise UAT Defects],

     [Efforts in Hours],

     [Release Status]

FROM

TestingEfoorts.qvd

(qvd);

Qualify*;

Unqualify [Project Name];

DefectList:

LOAD Quarter,

     Client,

     [Account Manager],

     [Project Name],

     Release,

     Month,

     Year,

     Id,

     Description,

     [Date Identified],

     [Root Causes/Reason Code],

     [Defect Type],

     [No.of Iterations],

     [Phase Injected]

FROM

DefectList.qvd

(qvd);

UNQUALIFY *

[cmorri1988]

change left join to inner join