Still a newby and trying to catch up on this holiday weekend. I have a file with all 50+ states. All i need to do is sort the file by the most common occurring state, which is CA. I don't want to drop any files. Thanks!
If you take the data down to a summarize, group by state and count state, you can use a join and join on state ( de-select state from right) and then sort your data on count descending. Now use a select to remove count.
your data is supported by state with most populated at top.
cheers,
mark
@tpostlewate A sample input and output would be helphere.
But maybe something like this?
Hi @tpostlewate
I posted below two examples of workflows accomplishing a sort by the most frequent state. One workflow demonstrates you can can count the frequency of which a state is present and the second workflow will do the same thing and also eliminate duplicate rows that have all the same state information and only keep the 50 states. This will give you a good basis to see how you can leverage Alteryx to accomplish this task. Feel free to provide any sample dataset in case you need more help with this task.
Pedro.
All of the states are standardized, so output would be CA at the top of the dataset with all of the other states following in alphabetical order. What would you put in each of those tools to get your output?
