Analytic App to Maintain Zip Code List for Offices

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.

Apps

Interface Tools

Accepted answers

JoeS

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

All comments

JoeS

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.

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235