topic Re: Outer Join resulting in additional rows in App Development

Outer Join resulting in additional rows

hitha1512 — Tue, 21 Feb 2023 16:27:07 GMT

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.

Re: Outer Join resulting in additional rows

E_Røse — Tue, 21 Feb 2023 16:06:30 GMT

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.

Re: Outer Join resulting in additional rows

vinieme12 — Wed, 22 Feb 2023 07:07:02 GMT

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 ;