Generate Output

Question

Hi

I want to create output for 3500 rows in one tab like :-

If have 10k row data then it should be divided into 3 tabs

Sheet1 - 3500

Sheet 2 - 3500

Sheet 3 - 3000

But it should be dynamic what ever number of rows I have in input it 3500 should be the limit of each tab.

Is it possible to that?

Thank you in advance.

Output Sample data.xlsx

binu_acs · Accepted Answer

@sgaryali one way of dong this

AngelosPachis · Accepted Answer

Hi @sgaryali ,

You can create a distinct sheet name every 3500 rows (or whatever number works for you) and then use that sheet name to change table name in the configuration of the output tool

Hope that helps,

Angelos

Emmanuel_G · Accepted Answer

Hi @sgaryali ,

One very easy way to do this with Tile tool.

You just edit the number of groups you want in tool.

Cheers !