LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: newbie

I have an output of rows with mobile numbers such as below. I want to insert a blank row after every group of the same mobile numbers like below before publishing in an excel output.

0400000090, xx, yy, zz
0400000090, aa, bb, cc

0400000091, xx, yy, zz
0400000091, aa, bb, cc

0400000092, xx, yy, zz
0400000092, aa, bb, cc

Any suggestions would be great. thanks !!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

Hi

Someone may have a better suggestion than mine but..., see the attached data flow.

The logic assumes the your input data is sorted by the field that contains the mobile numbers (TN in the example).
It also assumes the other fields in the records have a string data type.

Insert Blank Row When Value Changes.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: newbie

thanks a tonne. will give this a try !!