Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How can I add a column as the average of another column

s92ma
5 - Atom

How can I add a column B in alteryx where each cell value is the average of column A 

 

s92ma_0-1641576903421.png

 

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @s92ma 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1641577174368.png

 

1. Use summarize to get avg

2. Use append tool to add column to the data

 

Hope this helps : )

 

Labels
Top Solution Authors