Write csv with limit file size in alteryx

[pranpriyasha]

Hi everyone,

I want to write data to .csv file but I want to limit csv size = 500MB if csv file size > 500 MB then create new file csv.

please suggest me

[Matt_D]

Hi @pranpriyasha 

Not sure what version of Alteryx you have but if you have a version which has control containers, you could write the csv to %TEMP%, read it back in using the directory tool, using the size field you could either open the file and write it out the preferred location, or don't - browse tool / test tool error. Could also be written out elsewhere if > 500MB.

[OTrieger]

@pranpriyasha 

Not sure if that will be accurate 500Mb, but if you will check how many row of data in the csv will give you around 500Mb, then you can do a logic that Alteryx will put out a specific amount of rows and when that quota achieve write it to a new file. It will need to be in a macro so it will do it over and over till no data left to write out.

[apathetichell]

@OTrieger is correct - this is best done by number of rows. keep in mind that encoding/string types can change the size of .csv files.