Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Unchecking fields inside of Join not working on Outer Joins?

Highlighted
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. 

Highlighted
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.

Highlighted
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