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

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