topic Re: Dynamic Input: Using dummy input file for source template. Errors when run on server in Alteryx Server Discussions

Dynamic Input: Using dummy input file for source template. Errors when run on server

lowellsinghGP — Wed, 12 Feb 2020 14:38:46 GMT

I am using a dummy input data source template and it runs in desktop but when I try and run it in server it errors out saying it can't find the dummy file. I am using the dynamic input to generate the sheet names to add to the file path and later open those individual sheets with another embedded macro.

Re: Dynamic Input: Using dummy input file for source template. Errors when run on server

DavidP — Fri, 05 May 2023 15:36:35 GMT

I think dynamic input has to be able to see the template file.

Another way to do it is to create a batch macro with an Input data tool instead, with a control parameter and action tool to update the fullpath of the file you want to load.

I think this should work on server.

Re: Dynamic Input: Using dummy input file for source template. Errors when run on server

lowellsinghGP — Wed, 12 Feb 2020 19:08:48 GMT

Thanks DavidP

When you mean update the full path how does it recognize the sheet name? I am using dynamic input to pull the sheet names then I add that to the full path witch then gets fed into another macro that opens each sheet in an excel document.

Re: Dynamic Input: Using dummy input file for source template. Errors when run on server

DavidP — Wed, 12 Feb 2020 21:16:12 GMT

Just add the sheet name to the full path like this

...\foldername\filename.xlsx|||sheetname$

I’ll send you an example shortly.

Re: Dynamic Input: Using dummy input file for source template. Errors when run on server

DavidP — Wed, 12 Feb 2020 21:40:41 GMT

The attached workflow is not dissimilar to your workflow, but instead of using a dynamic input, it uses the same batch macro twice, first to read the list of sheet names and then to load the sheets

Re: Dynamic Input: Using dummy input file for source template. Errors when run on server

lowellsinghGP — Thu, 13 Feb 2020 13:59:30 GMT

Thanks DavidP

I am going to hardcode the sheet names into the formula tool since they will never change. However, this is great for dynamic files where sheet names are not consistent. I will use this approach for other workflows for sure.