Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

WildCard Input error

priyanka31
7 - Meteor

Hi,

 

This topic has been discussed before but nothing seemed to work for me. I have multiple folders with multiple excel sheet. This workflow is not designed by me, hence I feel it is difficult to troubleshoot as I am a beginner.

I keep getting this error when I run my workflow in the gallery. 

 

I use same workflow for 4 different countries (each country has separate folder with multiple excel sheets), it seems to work for all 3 except 1 country (1 folder which has about 15 excel sheets).

 

 the WildCard is configured this way:

 

priyanka31_1-1605820877703.png

 

with the below formula:

Switch([#1], "Check me",
"APLA", "\\ABC\GOT_FS\Logistics_Cost\Budget\APLA",
"EMEA", "\\ABC\GOT_FS\Logistics_Cost\Budget\EMEA",
"Greater China", "\\ABC\GOT_FS\Logistics_Cost\Budget\Greater China",
"North America", "\\ABC\GOT_FS\Logistics_Cost\Budget\North America")

 

priyanka31_0-1605820567358.png

 

Can someone please help?

4 REPLIES 4
T_Willins
14 - Magnetar
14 - Magnetar

Hi @priyanka31,

 

I may be able to help as we work at the same company (I recognize the server name).  I'll send you a PM with my direct email.

HomesickSurfer
12 - Quasar

Hi @priyanka31 

 

Is it possible that the file is open to another process or person, or non-existent?

priyanka31
7 - Meteor

Thank You 🙂

priyanka31
7 - Meteor

No, I checked that too. But no files are open anywhere.

Labels