community
cancel
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!
SOLVED

Pollutants max and min

Highlighted
Meteoroid

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.

Himal

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

 

Pollutants.PNG

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover 

Meteoroid

Thanks, @Bharti. It's working now.

Labels