Connect

Mhnd

Hey Experts,

I am new user of Alteryx

I created this workflow for data that I received weekly. I have two Excel files that include accident detail of some cities.

Florida is getting the lowest percentage of accident per population. I need to get what is the biggest number of each type of accident from the other excel files. 

what is the biggest number of rear-end collisions? "speed above 60 is 60 

what is the biggest number of Sideswipe Accident in Highways?

what is the biggest number of Head-on Accident in Highways?

what is the biggest number of Reckless Driving in Highways?

So, My workflow should answer what is the lowest state in accident per population? Then goes to other files and answer these 4 question.  

Accidents.yxmd

Accidents.xlsx

Accidents past week.xlsx

JoeHerbert

Hi @Mhnd First up, you can use the Union tool & Manually configure the fields to bring them together into one output file and rename the columns using the select tool. Then using a combination of Sort & Sample you can find the lowest State Accident/Population.

Secondly, similar usage of Union, Filter, Sort and Select to answer the other 4 questions: 

Please mark this solution as complete & check out the Getting Started Learning Pathway on community: https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117    to find out more about some of the tools used in the workflow! 

Happy solving 😄 

Joe 

Accidents States Completed Workflow.yxmd