Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Join Tool

stevenlsj789
8 - Asteroid

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!

 

2 REPLIES 2
jasperlch
12 - Quasar

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

 

Capture1.PNG

ponraj
13 - Pulsar

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

WorkflowWorkflowResultsResults

Labels