Hi team,
I have used interactive tools like drop down and numberic tools for the requirement.
However, when I run the workflow by clicking magic stick which is next to run button, it is asking output file is not connected or asking me to connect output tool..
All i need is to get the results in a window (for custom vales) after running the workflow instead of generating the output in a excel file.
Please help
@Inactive User
We can configure in the interface designer to see the result in Browse tool or other tools.
But not sure about the "Asking the output tool" , can you give a snapshot of your flow?
@Inactive User as @Qiu mentioned configure your interface tool and if you dont want your end result in excel just uncheck the output data. please see the below screen shot for your reference
Is this a duplicate thread @Inactive User? The app I provided in the thread below shows the results how you want (from a browse tool), and doesn’t output to an Excel.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Interactive-tool/m-p/963047#M237507
@DataNath I tried to implement to my workflow but it is giving a pop saying need to set output so i have attached output tool and got the result in excel file.
But i need to see in a window how you get it
@DataNath I am multiplying 2 columns and getting that result in another column. so i want to see only those 3 columns after providing user values but I am getting complete data
@Inactive User to only get those 3 columns, use a Select tool right at the end of your workflow and deselect all other fields that aren’t the 3 you want to see. As the others have mentioned, instead of using an Output Data tool at the end, just place a Browse tool at the end of your workflow and go into the interface designer (ctrl+alt+D) and tick the Browse tool in the ‘On Success - show results to user’ part of the configuration.
@Inactive User in the interface designer, in the properties window, you can choose what is shown to the user of the app. In your case, if you don't want to see the excel output, untick the excel file in the 'Open Files From These Tools' section
When you run the app, the excel file will still be written, but it won't be displayed to the user. You don't need an output file to run an app, so if you don't want the output written somewhere, then simply remove the output data tool.
If you want to only present the user with 3 columns, then you can use a select tool before the selected browse to limit the columns the user sees
Hope that helps,
Ollie