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
Solved! Go to Solution.
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 .
Thanks!! Worked like a charm, and like you said it's simple haha ;)
I had the exact same question, thanks for your response. The attached workflow worked like a charm !