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.
Solved! Go to Solution.
Hi Mhnd, welcome to the community,
Please could you upload the Excel file with the detail of the accidents? (In your workflow there is a 'Florida Accident in Details') that is not attached to the post 🙂
Thanks,
Joe
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
Thank you so much. That was the perfect way.