Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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.
Hi Morrison,
I want to perform inner join only
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
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 *
change left join to inner join