Hello everyone,
need your help in building up an analytic app which will cover up the following tools--
1. first of all, it will call an excel file as input.
2. say the input has 4 or 5 or more variables, the user will get list of all variable names and will keep only one variable.
3. next step is he/she will rename the variable as per wish.
4. Will remove all the duplicate and missing values, if any.
5. the final step is will put record ID for the existing observations and store the output.
To keep things simpler, I've attached one sample case.
All I want is that the user will see all the variables, drop all variables except "vendor_name" and rename it "supplier_name" and do the further processing.
I know this is pretty simple if I prepare an workflow, but seeking expert suggestions so that many user can use it easily.
Thanks in advance!
Solved! Go to Solution.
Hey @sg1207
See if this set up works for you
Part time Tableau, Part Time Alteryx. Full Time Awesome
So you will need two interface tools, the drop down tool and the text box tool.
You can then simply overwrite placeholders that you would have in the 'select' tool (to select only one field and rename it accordingly), and also the summerize tool, where you group by the variables, and finally the filter tool to remove missing values.
Example attached.
Ben
Did you try my version?
I compensated for any name changes
Part time Tableau, Part Time Alteryx. Full Time Awesome
No, standard tools..what error do you get?