Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bvssudhakar
Contributor II

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
Contributor

Re: how to perform join operation on particular field in qlikview

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

Re: how to perform join operation on particular field in qlikview

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

Re: how to perform join operation on particular field in qlikview

Hi Morrison,

I want to perform inner join only

bvssudhakar
Contributor II

Re: how to perform join operation on particular field in qlikview

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

Partner
Partner

Re: how to perform join operation on particular field in qlikview

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
Contributor

Re: how to perform join operation on particular field in qlikview

change left join to inner join