Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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 - Creator III
Partner - Creator III

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