We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.
Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

insert a blank row after every group of rows

Follow
Avatar
Infogix Support
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 !!
0

Comments

2 comments

Sort by Date Votes
  • Avatar
    Infogix Support
    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
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: newbie

    thanks a tonne. will give this a try !!
    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post