Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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