Output to file automatically splits into multiple files

[hemant86]

Hi Team,

I'm trying to create an output to excel file with almost 4 Lac(400,000) line items. I see that it is automatically splitting the output into multiple files instead of keeping it in one file. What is the reason behind this. I want the output in 1 file. Appreciate any help. Please find my O/p tool settings below.

[IraWatt]

Hey @hemant86,

In your second screenshot if you untick 'take file/table name from field' it will output all the information into one file. Are you looking to split the data into different sheets? 

[hemant86]

Thank @IraWatt for your response. But I need that since I'm tagging current date/time to the file name while producing an output. Please see the screenshot below. 

[IraWatt]

@hemant86 That should output everything into one file. Is this issue that you are getting slightly different seconds values and that's creating the different files? How do the file names differ?

[hemant86 · Accepted solution]

That's right @IraWatt . 3 files are created with 1 second difference. Screenshot attached. Using DateTimeStart() solved the problem. But any idea why its doing so.

[IraWatt · Accepted solution]

@hemant86, I would say its due to Alteryx running the workflow asynchronously. Meaning that it calculating files names and outputting whilst also calculating other file names. You could have gone with this setup to ensure that the time is only calculated once then its appended to your data:

[hemant86]

Thanks @IraWatt . Will check that out as well🙂