In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Take Max of One Column & Create New Column w/ All Rows Reading Max Value

DataUser
7 - Meteor

I have a Summarize function giving me the max of one column "27" and I want to create a new column in my data set and have all rows show "27". Is there a way to easily do this? Thank you

1 REPLY 1
KaneG
Alteryx Alumni (Retired)

Append the result of the Summarize back on to the dataset. If you have a group By on the Max, then you will need to join it back on via the Group By variable.

Labels
Top Solution Authors