topic Re: Analytic App to Maintain Zip Code List for Offices in Alteryx Designer Desktop Discussions

Analytic App to Maintain Zip Code List for Offices

chudson — Mon, 10 Sep 2018 19:40:54 GMT

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.

Re: Analytic App to Maintain Zip Code List for Offices

JoeS — Tue, 11 Sep 2018 12:07:59 GMT

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

Re: Analytic App to Maintain Zip Code List for Offices

chudson — Tue, 11 Sep 2018 12:47:29 GMT

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

Re: Analytic App to Maintain Zip Code List for Offices

JoeS — Tue, 11 Sep 2018 13:01:28 GMT

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.