community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Join tool

Atom

When using the join tool, is there a way to do a "select all" or do you have to select each column 1 by 1?

Alteryx
Alteryx

Hey @mrc 

 

If you're referring to which fields are visible coming out of the join, you can highlight multiple fields and select/deselect using the "Options" drop down to navigate to Select > Select Highlighted:

 

join_settings.JPG

 

For the join criteria fields you'd be selecting one field at a time in the "Left" / "Right" drop down menu

Alteryx
Alteryx

Hi @mrc ,

 

If you have a unique ID field, you can use Transpose before Join, so that you only join on a unique ID field, name, and value, instead of joining on 20 different columns.

 

clipboard_image_0.png

Sample Input (claim_id, then 20 fields that we want to compare - 

clipboard_image_1.png

 

Transpose - 

clipboard_image_2.png

 

Join - 

clipboard_image_3.png

 

 

Labels