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

Bangalore, IN

Welcome to the Bangalore, India Alteryx User Group! Please join us in sharing experiences, best practices, and knowledge. Bangalore User Group Leaders: Yugandhar Muley (Yug) , Nezrin Noushad , Sharon Colaco , Subrat Das
Welcome & Guidelines

Find tips to make the most of your User Group experience.

LEARN MORE
Reply
This is an open group. Sign in and click the "Join Group" button to become a group member and start posting.

Need clarity on Append Fields Tool.

Hi all,

 

I've gone through Append Fields Tool but, I still confuse in which use cases we use it. In the Tool mastery series there is no any clear documentation on it. Always it is confusing me. I've gone through it many times; although I still confuse.

 

Kindly please let me know the possible use cases on using this tool and how frequently we use it. Also please do let know the pros and cons of this tool.

 

Many thanks!

B. Sreenivasa Teja.

1 REPLY 1
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
Via iPhone this is terse:

Use the tool to add a single or set of constant values to every record. While you could write a formula with the fields for a similar effect, sometimes you might summarize data and append the total of data (e.g. count or sum) to every record.

If you need to create a set of rows for every record, you can bring in the desired rows ( e.g. stores) and get multiple identical rows from the target times the number of source rows appended.

If you need to have every combination of rows, you can append data to itself and create a Cartesian join.

Please go to academy and find the interactive lesson on the append fields tool. It does a good job explaining the usage

Finally, I use it often!

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Reply
This is an open group. Sign in and click the "Join Group" button to become a group member and start posting.