Hi
I need below scenarios Using interface tools to allow the user to:
> Give the option to change the file but only to .xlsx
> Give the option to write to different sheets based on Location
I Wanted it in analytic App
Thanks
Yogish B
See attached for an example. The first set of interface tools above the Input tool will allow a user to select a file to run the workflow with. The format is limited to only excel files.
I'm a bit unclear as to your second requirement, so I built two scenarios. The first one uses a folder browse for the output. This allows a user to select the location of the output file, but will not change the sheet name. The second option allows a user to enter a sheet name to be used for the output, but the location will remain as is. You could technically combine the two to first allow a user to select an output location, and then enter the sheet name. The format output would be an excel file still.
Hope this helps!
Hello @Yogish ,
this is doable. I recommend that you invest some time to get familiar with Analytical Apps here:
https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Creating%20Analytic%20Apps
Have a great day
Phil
Please refer the Link.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Analytic-app-file-browse-ask-user-for-sheet-name/td-p/570463
When users can select sheets, users can other type files.
But they can only select Excel files, the user can't select the sheet.
