Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
hitha1512
Creator
Creator

Outer Join resulting in additional rows

Hello Team,

I am going wrong in Outer join, which is resulting in multiple rows instead of single row as output. Please find the below code used and the resulting output.

hitha1512_0-1676994398266.png

 

PC_name and BaseItemNew fields added to pivot, is giving me the duplicate rows, as i am assuming its coming from 2 different tables

Code used:

Final_temp:

NoConcatenate

Load 
PC_Name as PC_Base_Name,
Hrd_MonthYear as Date,
Country,
PC_Name

Resident Hardware_Final;

Outer Join (Final_temp)

Load 
BaseItem as PC_Base_Name,
MonthName(DateNew) as Date,
INCCountry as Country,
Max_Total_Min_PerDay,
Number,
BaseItemNew

Resident Final_INC ;

 

any help would be appreciated. 

Labels (1)
2 Replies
E_Røse
Creator II
Creator II

I am guessing the AutonumberHash is not returning the same values, since you are using different fields. Try removing the lines with KeyTest.

Are you intending to join on all of the fields PC_base_name, Date, and Country? If it is still not working as you expected, try concatenating the tables instead of joining them )

Please like and mark my answer as a solution, if it resolved your issue.

vinieme12
Champion III
Champion III

The Rows are getting duplicated you would actually have more than one row for the same PC_BASE_NAME

check each table separately without joining.

 

 

QUALIFY *;

Final_temp:

Load 
PC_Name as PC_Base_Name,
Hrd_MonthYear as Date,
Country,
PC_Name

Resident Hardware_Final;

 

Final_INC_TEMP:

Load 
BaseItem as PC_Base_Name,
MonthName(DateNew) as Date,
INCCountry as Country,
Max_Total_Min_PerDay,
Number,
BaseItemNew

Resident Final_INC ;

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.