Build Analytic App

[Yogish]

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

[PhilippK]

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%2...

Have a great day

Phil

[AkimasaKajitani]

Please refer the Link.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Analytic-app-file-browse-ask-user-for-...

When users can select sheets, users can other type files.

But they can only select Excel files, the user can't select the sheet.

[echuong1 · Accepted solution]

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!