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?
Solved! Go to Solution.
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
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.
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?
it is possible to add more interface tool. In fact, the example from Alteryx is an app and you can improvise from there.
Thanks! How could I utilise this type of interface + a macro?