SOLVED
How can I add a column as the average of another column
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
s92ma
5 - Atom
‎01-07-2022
09:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How can I add a column B in alteryx where each cell value is the average of column A
Solved! Go to Solution.
Labels:
- Labels:
- Batch Macro
- Developer
- Expression
- Workflow
1 REPLY 1
22 - Nova
‎01-07-2022
09:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @s92ma
Here is how you can do it.
Workflow:
1. Use summarize to get avg
2. Use append tool to add column to the data
Hope this helps : )
