ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

Unchecking fields inside of Join not working on Outer Joins?

KaiLarsen
9 - Comet

I was so sure that in past versions, unchecking a field in the Join tool's embedded select would remove those fields regardless of whether I was turning it into an outer join through the union tool or not. I may be a version behind. Regardless, I see the inner join output missing those columns, but the following union picking them up from the left or right unjoin anchors. 

DavidP
16 - Nebula
16 - Nebula

Hi @KaiLarsen 

 

As the left and Right outputs of the join tool are unjoined records, they will always contain all the fields from their respective inputs. The Select functionality in the Join tool will only apply to the joined records.

 

You would have to add a Select tool to the Left output before the Union tool to remove the fields you don't want in the output.

KaiLarsen
9 - Comet

Thanks. So I guess my memory is just wrong. What is the use case for deselecting a field from the embedded select tool and actually wanting that field in your left unjoin column, you think?

Labels