Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
bvssudhakar
Creator III
Creator III

how to perform join operation on particular field in qlikview

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

6 Replies
cmorri1988
Creator
Creator

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
Contributor III
Contributor III

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
Creator III
Creator III
Author

Hi Morrison,

I want to perform inner join only

bvssudhakar
Creator III
Creator III
Author

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
Partner
Partner

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
Creator
Creator

change left join to inner join