Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!

Pollutants max and min


HI All,


I am new on alteryx. I have a set of data that contains the pollutant_code, year, source of pollutant and total emission. I want to give a name to a particular pollutant code like 7439921 -lead,743992-zinc,7439923-nitrogen,7439924-co. Then I want to find the maximum and minimum of total emission for a particular pollutant. Here, I am attaching a dummy data. Can anyone help me in this?


Thanks in Advance.


Alteryx Certified Partner

Hi @Himal,

I am attaching the solved workflow. I hope that helps.Screenshot (132).png

Alteryx Certified Partner

Hey @Himal


I'd build a little lookup table that has the names in which you can then join back to your dataset and use a formula tool to build your concatenated Code + Name field.


Then using summarize tool to find the Min/Max for each pollutant




Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover 


Thanks, @Bharti. It's working now.