Alteryx Server - Wildcard input not working

I'm trying to upload a workflow from Designer to Server. When I save it to the Gallery, it gives me an error message "file not found" when using a *.xlsx wildcard character for an ambiguous file name. However, the same workflow works in Server if I reference the file name directly! But when I switch to usingthe wildcard character *.xlsx, it gives this error message. Why is this happening? Is there a way to use the wildcard character when inputting files in a workflow on Server?

Wildcard Data Input Error Server.png

Input

Error Message

Server

Accepted answers

MarqueeCrew

@AndrewKwast,

This is the type of post that I would rather watch than seeing a single obfuscated photo of. If the same workflow runs on server and the concern is that the error message displays, then you can STOP (uncheck) the action during the SAVE to "Validate workflow then save" that is available in the WORKFLOW ACTIONS dropdown. When I define EXCEL searches, it would look like: *.xlsx|||Sheet1.

A little more information would be helpful.

Cheers,

Mark

All comments

MarqueeCrew

@AndrewKwast,

A little more information would be helpful.

Cheers,

Mark

AndrewKwast

Let me try to clarify the issue. It seems to me that this is a Server issue specifically. Also note: I'm required to and currently use v11.8 only.

Below is a screenshot of the workflow I run. This workflow runs without any errors when I run it in Alteryx Designer.

Workflow Wildcard Error.PNG

The issue occurs when I try to save the workflow to Server. I go to File > Save As > My Company's Gallery.

Server Upload Settings.PNG

"Validate workflow then save" is already checked. When I click "Save" I get the error message saying "Tool 1 - File Not Found".

I tried this exact same workflow without the wildcard character, i.e. specifying the file name directly, and the workflow successfully saved to Server.

Is this normal for Server to get errors when using wildcard characters? I don't know why I'm getting this issue.

AndrewKwast

Thank you @MarqueeCrew

The issue was that the input needed to reference the UNC path.

This can be resolved at Options > Advanced Options > Workflow Dependencies > All UNC > Ok.

su-lee

Was this every resolved? I'm running into the same issue.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703