Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Union multiples files but some files not contain records or fields are empty

Alteryx Partner

i use input data and output data to union all files and create a field, but some files are empty or not contain fields, how can i design it for filter empty files not contain records... please

Alteryx Certified Partner

Hi @eherrera 


Could you please share your workflow with us so we could see what exactly is going on with empty files being generated?

How do you union them and create a field? 


Alteryx Partner



You can use the Directory tool to load all the filenames in a folder with all their attributes and filter on size > 0. The use a dynamic input tool to load all the files. Like this:


text files.png