As per the title, I am trying to make an analytic app that allows end users to input an Excel file that has 8000+ columns.
As you know, users can sometimes select the wrong columns by accident - I am trying to add a feature that showcases them a confirmation page of sorts that showcases them the fields that they have selected.
Is this possible within Alteryx Analytic App at this point?
Solved! Go to Solution.
First I would like to know how you are thinking how a user will analyze 8000 columns?
Do you intend to put it in alphabetical order? It's a column for a week of visual work :)
That’s the thing - the user is not planning to analyse 8000 columns!
The file is a dump file by IT and they need to select different columns for different analysis each week. They have no access to IT DB.
So, they need an interface to ingest the file and egress the necessary data which is then connected to another analytic app that does the dynamic calculations.
Ive built it already but the feature that’s missing is just the option to search for fields within the analytic app and also the option to confirm selections.
To add on to my write up here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Dynamic-Select-Getting-Boolean...
There is currently no way for end-users to confirm selections per se on the interface tool because it is not actively showcasing what was selected before running.
So, the only alternative is to use a Field Info tool connected to a Browse Tool, and labelling the Browse Tool as "Selections", and when running the options on Analytic App, the first thing that end users see is the Field Info data showcasing the number of columns in rows with their details as per the Field Info tool.
If it's not up to par, the end user can simply close the results, and go back to the Analytic App to make changes.
This is not the best way, but the only way I've found so far. If anyone sees this in the future, hoping this helps.
User | Count |
---|---|
106 | |
85 | |
76 | |
54 | |
40 |