Join question

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

Input

Join

Accepted answers

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 .

All comments

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

syedimranhashmi

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703