Forum Discussion

MarianneGale's avatar
MarianneGale
Qrew Member
19 days ago

How to split an Export file which is too big

I need to export port a file which has over 400 fields and years of data.  When I try to export I get the following error.

is there a way to split the data into chunks?  I still need all the data,  and would like to split in yearly chunks.  Is there a simple way to do this?  I am a total novice at this.

  • Sure, just make a report  and include all the fields.  There is an option under the more menu or the 3 dots menu to export or save as spreadsheet.

    So then the issue is how to chunk the data into several exports.  It depends on bow large you data set is in terms of rows, but for example you can make a field called [Last Digit of Record ID#] with a formula of Right(ToText([Record ID#]),1)

    That will give you a text value between 0 and 9, and you can play with report filters to see if you can get away with exporting half at a time or if necessary 1/10th at a time, or somewhere in between.   

1 Reply

  • Sure, just make a report  and include all the fields.  There is an option under the more menu or the 3 dots menu to export or save as spreadsheet.

    So then the issue is how to chunk the data into several exports.  It depends on bow large you data set is in terms of rows, but for example you can make a field called [Last Digit of Record ID#] with a formula of Right(ToText([Record ID#]),1)

    That will give you a text value between 0 and 9, and you can play with report filters to see if you can get away with exporting half at a time or if necessary 1/10th at a time, or somewhere in between.