Output to file automatically splits into multiple files

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.

image.png

Common Use Cases

Accepted answers

hemant86

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.

image.png

IraWatt

@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:

All comments

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.

image.png

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

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.

image.png

IraWatt

hemant86

Thanks @IraWatt . Will check that out as well🙂

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335