User input where the file is outputted, append 2nd output to 2nd tab

Hi,

I am trying to create an analytic app on the server based on user input.

A user will input the full path and file name of where the file DataComparsionResults.xlsx will go. (they can name it whatever they wish.)

I have a 2nd output, can I somehow make this append to the DataComparsionResults.xlsx but another tab?

How can I put the 2nd output into the 1st output but another sheet?

Thanks.

Custom Tools

Accepted answers

csmith11

Sorry, You'll want to use a Text Box to capture the File Name of your user. The Text Box then Updates the File Name in the UNC Path. This Updated UNC Path is then Use when creating your Output File.

Here what the user Interface will look like on the Server:

All comments

csmith11

Here's a working Example Attached:

Here's what the server interface looks like:

Here your Output:

Two Separate Sheets Created:

Screenshot of Workflow:

Dynamic Output.yxzp

csmith11

Unfortunately, if you are wanting to use UNC file paths or any exact file path, Server doesn't handle these the same way Designer does. The workflow I shared should behave exactly as you describe in Desktop Designer. But on the Server it will only behave as illustrated in my screenshots.

I couldn't find a way that the Server can capture the UNC path dynamically. So if you are looking to allow your user to Dynamically Point to a location on your shared drive, the only solution I have is to use a Text Input Tool where your user Pastes the UNC path directly. (Still not letting your user browse for the path) But this Typed Out UNC Path could be used for output purposes.

wonka1234

@csmith11 thanks.

So i am having issues, when I publish to server and run, 2 things are happening in the output:

1) Writing to the path I have saved in the designer (works fine)

2) Inputting file path error. ie C:/Users/Me/excel and using dropdown for .xlsx

Can you help with 2), just outputting the file to a user specified location (with the 2 tabs)?

Here is what I have tried:

But when I enter in the full path I am getting error:

I have access to the folder...not sure why it isnt outputting.

csmith11

Sorry, You'll want to use a Text Box to capture the File Name of your user. The Text Box then Updates the File Name in the UNC Path. This Updated UNC Path is then Use when creating your Output File.

Here what the user Interface will look like on the Server:

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703