Split excel file every 1000 records

[BautistaC888]

Hello,

I have an excel database and i need to split it.

Every 1000 records, i need to create a new file.

For example:

If the database contains 2550 records then the outputs will be:

Database1.xlsx (First 1000)

Database2.xlsx (Second 1000)

Database3.xlsx (The rest)

The problem is that the number of records change day by day, so i need help to create a dynamic way to split them.

Thank you.

[atcodedog05 · Accepted solution]

Hi @BautistaC888 

Here is how you can do it. You can use record id tool and split data into blocks. This block name can be passed as filename.

Workflow:

1. Using record id tool to get row id.

2. Using formula tool Ciel([rowid]/1000) this way 1-1000, 1001-2000... will converted to blocks 1, 2... Using this to create filename.

3. Configuring output tool change path from column which splits and generates data into Database1.xlsx, Database2.xlsx ...

Hope this helps : )

[BautistaC888]

Thank you, the solution works in designer.

But once i uploaded to the server, i experienced the following error.

[atcodedog05]

Hi @BautistaC888 

You need to give the full path of the files in the formula tool which is accessible by gallery. Like below

Hope this helps : )