Join Tool

[stevenlsj789]

Hello, 

I have two simple files in the format that I am trying to join in the attachment below. Both are related to standard financial statements. And I want two files to join based on the description but to include all description and amounts (even if it's zero). 

Is there a way I can achieve the intended result with Join or is there another tool for that? Thank you!

[jasperlch · Accepted solution]

Hi @stevenlsj789, this could be done by adding a Union tool after a Join tool:

[ponraj]

Here is the sample workflow for your case.   Hope this is helpful. 

WorkflowResults