Output to a File creates two files - why is this happening?

[Mark_Lurie]

Is this a normal thing, or is there some setting that limits the number of rows for any output file?

As you can see, I have 678 records in my output and the tool is automatically splitting it into two files.  Is there a setting that will force it into one file or stop it from doing this?

Also, here are my output settings:

Thanks,

Mark

[Mark_Lurie]

I have also tried doing a max on the DateTime_Out field but that doesn't seem to help.

[patrick_digan · Accepted solution]

@Mark_Lurie This may not apply in your case, but I've used DateTimeStart() to get the same Date Time for all my fields across a workflow.

[VickieDex]

Thank you so much for this conversation!!  I started thinking about the Date/Time formula in my output.  What I found was that I had to sort my column that was used to create my individual files, then the 2nd file was not created.  This happened because I had 2 sets of data with different dates stacked with newer date at the top and older date at the bottom.