Join question

[scottjanse1]

Hi all,

I want to join a dataset with another one and am doing so by the join tool. However, some fields are not in the other dataset, which as a result excludes the data that is in one dataset and not the other. I actually want to join the matching fields/data and if it is not in the dataset I want it to give it a '0' (zero). Can someone help me with this?

Thanks,

Scott

[s_pichaipillai · Accepted solution]

@scottjanse1

its simple.

Grab the Matching rows from JOIN 

then you may see R and L output . based on your Choise , select the Appropriate output and add Formula tool for putting default value 0

then Union both I and other output 

thats it :)

PFA sample may guide you

In this sample, we have a customer "E" who did not do any transaction , but i want to show his sales as 0 .

[scottjanse1]

Thanks!! Worked like a charm, and like you said it's simple haha ;)

[syedimranhashmi]

I had the exact same question, thanks for your response. The attached workflow worked like a charm !