Data Split in 5 row of Sequence Wise

[Rhaldhar]

Hi All,

I have below data product wise and want to split the data in 5 rows along with sequence wise. Please help me to get the result as shown in second screen shot.

First screen shot (Raw data)

second screen shot (result highlighted in yellow)

Thanks,

Rajeev

[usmanbashir]

@Rhaldhar - use the tile tool with equal records configuration. Hope this helps!

[Rhaldhar]

@usmanbashir Hi, I have used but it is not giving me the correct result somewhere 6 rows calculating (highlighted in yellow) instead of 5 rows. please refer below screen shot.

[usmanbashir]

Can you add in a Record ID tool then add a formula tool with expression as below?

CEIL([RecordID]/5)

[Rhaldhar]

@usmanbashir Hi, Could you please share a workflow and example so that I can do accordingly. Thanks.

[usmanbashir · Accepted solution]

@Rhaldhar - please see attached workflow. Apologies, this solution does not use Tile as I initially mentioned. I have included sample data for reference.

[Rhaldhar]

@usmanbashir Hi, Thank you so much for your support, perfect solution.