cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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