Build Analytic App
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Data Investigation
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @Yogish ,
this is doable. I recommend that you invest some time to get familiar with Analytical Apps here:
Have a great day
Phil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please refer the Link.
When users can select sheets, users can other type files.
But they can only select Excel files, the user can't select the sheet.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!