community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Create a blank when a file doesn't exist

Highlighted
Meteoroid

I am trying to gather data from a timed job. There are 5 machines that can spit data out. The bit that Alteryx doesn't seem to like is when one of the machines does not have a file to output. At that point the whole thing comes to a halt and fails. Is there a way to have Alteryx use the file produced if there is one or a dummy file if there isn't? Another option would be for Alteryx to check for the file and skip it if there isn't one. 

Alteryx Partner

HI,

 

I may be misunderstanding this but I would use the directory tool to identify the files, potentially have a dummy in the locations if needed, then use a dynamic input to read the files as required.

 

hope that helps

Meteoroid

Very good answer and I think it will be the right one. I am unsure how exactly to use it. I have played around a bit but am not quite there yet. 

Meteoroid

I found a Youtube video that explained it. Than you! That is exactly the answer I needed!

Alteryx Partner

Great stuff. I always forget about the directory tool.  :)

Labels