Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Delete Records from Input file before outputting a file with just headers


I am wondering if there is anyone out there who might have a solution for having to empty rows 2+ from an input file after it has been read and used so that the output file only has headers.

This is for an automated report that runs daily based on individuals putting in a list of records they need a report for and then I need to leave it empty so that on a holiday it would have no records to pull as the list would be empty.


The file I am working with is an xlsx



If you don't need a dynamic file name or anything like that, you can do this with the Sample tool, by selecting 0 records, which will leave you with only headers.


Hope this helps!