Split the output file in multiple files

[msantoso]

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

[JoeS]

Hi @msantoso 

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?

[Ladarthure]

hi @msantoso,

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!

[msantoso]

Hi Joe,

I want to produce csv files.

and yes I mean name of the columns

thank you

[msantoso]

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 

[msantoso]

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

[JoeS]

@msantoso 

The output option for CSV with the header is this one:

If that's checked each file should then have the column names as the first row.

[Ladarthure · Accepted solution]

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!

[msantoso]

Hi Joe, 

sorry about this silly question! I never had a precise look at this option as the outputs always came out with column names. 

[JoeS · Accepted solution]

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