Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Pollutants max and min

Himal
6 - 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

3 REPLIES 3
bharti_dalal
10 - Fireball

Hi @Himal,

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

LordNeilLord
15 - Aurora

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 

Himal
6 - Meteoroid

Thanks, @Bharti. It's working now.

Labels