Building a macro / app to allow user to produce differnt output lists

I'd like to build an app that gives the user the option to select from a list of fields, and then generate separate outputs (probably excel files) containing lists of the unique values from those chosen fields.

I have got stuck at the first hurdle! I thought having a batch macro in the app which would run through the user selections in turn could be a good idea, but I can't think how to configure it.

Any ideas?

unique app attempt.yxwz

Output

Apps

Batch Macro

Accepted answers

mst3k

You could solve this with a batch macro but I don't think you need to. A standard macro could provide a field selection, compute the unique values, then output to split files. See attachment for an example. I set it up to use referential path, so you'll need to save this to a folder somewhere before you run it. Then it will create Excel files in that same folder, one for each of the fields you select. It worked as intended when I tested it

Workflow.yxzp

All comments

One way is to use the Example file in Alteryx which you can access by clicking on the interface tool and then click on the Hyperlink to open example.

With this example file as a starting point, all you need to do is to add a Summary Tool after the Select tool to list the unique values.

ListBox interface tool.PNG

chickenlicken

Thank you, this seemed perfect actually. Would it be possible to add an interface tool so that a user can run it as an app to answer the questions in the control parameter?

chickenlicken

Thanks! How could I utilise this type of interface + a macro?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703