Hello Alteryx Gurus,
I am attempting to rebuild a workflow that I can hand off to the marketing department so they can maintain this list themselves.
Process flow I am envisioning:
Input File (csv, excel) >> dropdown to select office >> add new zip codes OR mark in-active >> overwrite existing worksheet.
I am currently having trouble with the dropdown populating with a distinct list of offices to choose from.
Example input data (1 office; there are actually 30):
Office | Zip Code | |
Arlington | 98798 | |
Arlington | 65465 | |
Arlington | 65484 | |
Arlington | 54865 | |
Arlington | 54984 | |
Arlington | 54684 |
Eventually, I'd like to be able to add new offices as well but if I can get the above done it would be tremendously helpful.
Solved! Go to Solution.
I figured there would be some good examples somewhere! Thanks for the links!
You're welcome!
They aren't exactly the same as what you require but hopefully you can implement the logic required. Reply back on here if you do get stuck at any point.