Generate Output

[sgaryali]

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.

[binuacs · Accepted solution]

@sgaryali one way of dong this

[AngelosPachis · Accepted solution]

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 solution]

Hi @sgaryali ,

One very easy way to do this with Tile tool. 

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

Cheers !