Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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 ;