Outer Join resulting in additional rows

[hitha1512]

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.

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. 

[E_Røse]

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]

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 ;