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

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

When to use Join vs Append

Alteryx Partner

Hello!

 

I feel like this is a simple answer and I kind of feel like I know the nuances between when to use the tool. I'm finding it hard to articulate in which use cases one is better than the other. Can anyone think of when would best to use append instead of join?

 

Thanks!

 

Emily

Alteryx Certified Partner
Alteryx Certified Partner

When you have a set of constant values to add to all records, use the append function. 

 

 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
ACE Emeritus
ACE Emeritus

- Use the join when you have multiple fields to join on

- Append tools only do Cartesian joins, essentially a blind join between two data sets.  You can wikipedia Cartesian join for deeper explanation

- I believe there is an record limit on the source side input of an append tool because it can explode your data set and crash your module very quickly if done wrong

 

For every 1000 joins tools I have used I might use 1 append tool.  If you don't have a common key between your data sets then Append tool will work.

Labels