Analytic App to Maintain Zip Code List for Offices

[chudson]

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.

[JoeS · Accepted solution]

Hi @chudson

I think you will need to create a chained app.

The first app can read the full file and create the unique list of offices, the next app can then allow the selection and output to be updated.

We have a couple good links available for examples here and here

[chudson]

I figured there would be some good examples somewhere! Thanks for the links!

[JoeS]

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.