Check file availability before reading the data

[harish_alt]

Hi,

I am new to Alteryx and I need to check if a file is available in a specified path. If it exists, need to proceed with reading the file. If not exists, stop the workflow execution. Please help.

Thanks in advance.

[AngelosPachis · Accepted solution]

Hi @harish_alt ,

You can use a Directory tool to read all files within a specified path. That will only bring you information about the files in the specified path, such as the full path, the filename the extension, when the file was created and was last modified.

You can use a filter tool to only keep the file that matches your criteria or check if the file you are looking for is contained within the specified path. If it's there that will fall out of the T output anchor of your filter tool, which you can then connect to a Dynamic Input tool that will read the file.

Hope that helps,

Angelos 

[Jan_C_Ott]

you could start with a DateTimeNow Input then go to a formula tool and use the FileExists() function. Then go to a filter tool that  if true leads into a dynamic input.