cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We’re thrilled to announce our newest Alteryx Designer Expert Certified users! Learn more.
SOLVED

Join Tool

Highlighted

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!

 

Bolide

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

 

Capture1.PNG

Quasar

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

workflow.PNGWorkflowResults.PNGResults

Labels