This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The output in your example is in line with what I am looking for, but is there a way to choose the "category" by manually selection for each service e.g. via drop down?
So question in the interface should be e.g.
"Please select category for [service]"
and then the user can choose one of the options of table 2.
it should then run through all lines until all services have a category.
The background is that e.g. "service A" might have another category each month. I cannot avoid the manual category setting, but I would love to do this task in Alteryx still the rest of this workflow is already in there. it will be about 50 selections each month.
I performed it dynamically as you asked. The first file, dynamic selection_0 is an APP which will create with your table 1 the inputs for the interface. They will be saved on a file which I did name TEST FILE in my case. Be sure that on the interface designer (Control + Alt + D) you select the 'on success run another analytic app' (as seen on the image) and select the other app which i have uploaded.
The second app will pick the names and values from the first output generated and use them on the interface.