Alteryx designer Discussions

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

Join tool dropping data that doesn't join

Highlighted
Meteor

I'm trying to tie together two data sets with a join tool, but it's only keeping the data where the match rules are met. I'm trying to keep all data from the left data set even if there's not a match. Is there a setting to change this? Would unionizing the left output with the joined output be my best route?

Highlighted
Alteryx
Alteryx

You are correct.  A union after the join to bring in the left data would perform a Left Join.  The Join output only gives the Inner Join.

Regards,
Stephen Ruhl
Customer Support Engineer

Labels