Result of Join as 0 but need to set field value

[Abhii2658]

So, I have 2 Datasets which I need to Join on the basis of 5 fields. Then I need to set the value of the Join result as "Setting" in case all 5 fields match and "No settings" in case any of the 5 fields do not match. 

I need help in figuring out how to set the value of a new field named FINAL OUTPUT - "No settings" from the result of join function wherever the join condition is false. I do not have any input to set the formula, as none of the 5 fields match and i have to set the FINAL OUTPUT as "No Settings"

DataSet 1
A	B	C	D	E	F	G	H	I	J
DataSet2
A	B	C	D	Z	X	X	Z	X	X

So field 5 is not satisfying the join and based on this outcome i need to change the value for "FINAL OUTPUT" as "No settings"

I hope i am making sense here. 

[atcodedog05 · Accepted solution]

Hi @Abhii2658 

Here is how you can do it. You need to take left outer join (I am assuming left data is your main data). You can do a left outer join by using union tool among join and left unjoin like below.

Workflow:

Hope this helps : )

[Abhii2658]

Perfect