6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Left and Right results on Join tool to use Renamed Columns

I haven't been able to find a similar idea, but I have a scenario were I'm fully joining a dataset but I get a mismatch of column names.

 

When using the column renaming functionality in the Join tool, data sent through the Left or Right connector is not renamed. When I'm performing a Full Join the Union tool is adding these columns to the resulting table.

 

The renaming column functionality of the Join Tool should apply to all join types for consistency. My workaround has been to avoid renaming columns in the Join tool if aiming to perform a multi-join.

 

Capture.PNG