question on Joining two datasets with common field

[ayush_mishra]

I want to join two datasets with common field taking input from different sources. please check file for details on query. thanks!

[Qiu · Accepted solution]

@ayush_mishra 
I think you are doing alright, just somehow gets twisted.

And if you are not sure which will be null for the left and right, we can do something using Formula Tool.
Please adjust the formula if the left and right income are not equal.

[ayush_mishra]

Thanks @Qiu 

[Qiu]

@ayush_mishra 
Thank you!