Split the output file in multiple files

Hi everyone,

I need to split the output file into several ones with less than a thousand lines in it.

I've read many discussions around this topic : use of the TILE tool, the CEIL function,

and even tried to build a sample file with the first 1000 records.

all these solutions produce output files with no headers.

Did I forget to specify something? or is it the normal way these solutions work?

thank you

-ms

Transformation

Preparation

Accepted answers

the "." is for the same repository,

the par ".\test_" is to give the file a name (a first part) then I use + tostring([FILE]) to get the number of the file created by the formula and finally I give the extension of the file.

when you run the workflow, you have the files generated in the same repository. In your case I guess in the download folder, but you cna change the "." bat wherever you want!

No worries at all, have you been able to get it to work how you need?

hi

thank you for these explanations.

they will be very helpful for my next output filenames!

thank again!

myriam

All comments

The header row is an option within the output tool itself.

What file type are you outputting too?

And just to check, when you say header, do you mean the names of the columns?

I did a sample workflow, it works for me, you just have to change the path and the formula to get what you want exactly!

sample_split.yxmd

Hi Joe,

I want to produce csv files.

and yes I mean name of the columns

thank you

Hi Ladarthur,

thank you for your solution. It worked 🙂

can you explain me this syntax:

.\test_"+tostring([FILE])+'.xlsx'

why did I find the 10 files in my Download folder?

thank you

Hi Joe,

I checked the output tool and could not find any option re column names.

can you tell me where to look at?

thank you

myraim

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703