Data Split in 5 row of Sequence Wise

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)

First screen shot (Raw data).png

second screen shot (result highlighted in yellow)

Second screen shot (result shown in last column in yellow).png

Thanks,

Rajeev

Workflow

Accepted answers

usmanbashir

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

Splitby5.yxmd

All comments

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.

Result split rows.png

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703