Dynamic input fails where file size is zero

ChrisDL

Hi everyone

My workflow has a list of file locations and I am using a dynamic input tool to input those files and extract some data - a few of the files on the list have a size of 0kb (probably due to a failed deletion process in the application that created them) but I do not know which so the workflow fails with a no fields found error when it finds one.

The files in question are .dta files and I am importing them as csv files with no delimiters (I only need to capture the first few hundred characters)

Is there a way to make Alteryx skip the files with a zero size without using a directory tool to scan the folders which will take far too long?

mceleavey

Hi @ChrisDL ,

Use the Directory tool to read the files in those locations. In the Directory tool you will see a column called "Size":

Apply a filter to where Size>1kb (for example). This will remove those files that don't meet the required minimum size. This will be the list of files you dynamically load in the Dynamic Input tool.

Hope this helps,

M.