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

how to perform join operation on particular field in qlikview

bvssudhakar — Wed, 25 Nov 2020 16:16:04 GMT

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

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

cmorri1988 — Thu, 04 Oct 2018 14:20:43 GMT

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);

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

shwethaa — Thu, 04 Oct 2018 14:25:30 GMT

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.

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

bvssudhakar — Thu, 04 Oct 2018 14:39:09 GMT

Hi Morrison,

I want to perform inner join only

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

bvssudhakar — Thu, 04 Oct 2018 14:40:42 GMT

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

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

raman_rastogi — Thu, 04 Oct 2018 14:41:57 GMT

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 *

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

cmorri1988 — Thu, 04 Oct 2018 15:09:51 GMT

change left join to inner join