We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Analytics Hub

Find answers, ask questions, and share expertise about Alteryx Analytics Hub.
SOLVED

AAH - Input Tool with Wildcard <UNC>\*.xlsx Invalid Dependency

KOBoyle
11 - Bolide

I have an Input Tool with a 'AE*.xlsx' wildcard reference to process all Excel files with a certain prefix in a UNC location. The same workflow also has an Input Tool referencing a single Excel file. When I save to AAH, the dependency for the single file is setup correctly, however the dependency for the Input with the wildcard initially shows as invalid. When I try to edit to the UNC folder location and Validate, I get the following message. The workflow errs when I run it with this configuration.

 

Is there a way to configure the workflow to run on AAH with wildcard references?

 

KOBoyle_0-1614030379462.png

 

KOBoyle_1-1614030379467.png

 

2 REPLIES 2
BryceL
Alteryx
Alteryx

Hi @KOBoyle ,

 

Unfortunately, this functionality is not yet available in Analytics Hub, but it is something we are actively looking into and working to support. 

 

In the meantime, you may be able to modify your workflow to achieve the same result. I was able to use a Directory (specify UNC path and wildcard query) and Dynamic Input (Pull files listed from Directory - Field: FullPath, Action: Change Entire File Path) to achieve the same behavior as an Input Data tool with a Wildcard. These tools will not appear in the Dependencies section of Analytics Hub and cannot be modified, but they can run successfully provided the Run As account has access to the network/UNC location specified.

 

Please look for Hub to support use of wildcards in the Input and Output tools in an upcoming release. Until then, I hope the above workaround accomplishes your use case.

 

Thanks,

Bryce

KOBoyle
11 - Bolide

@BryceL 

 

The workaround is a viable option. The only drawback is that we need to persist a template file for the Dynamic Input tool in source folder that normally has a changing set of files over time, so it might get moved inadvertently. I think we can make it work though.

 

Thanks,

Ken

Labels