Highlighted
Seven Stars

How to group records and send first record of group to online file and same for rest

 Hi Folks,

 

I need to group the records coming in email column and send the first record of each group into one file and next second record of each group to another file and remaining records also same.

Ex : 

a@a.com

a@a.com

b@a.com

b@a.com

a@a.com

c@c.com

 

As per above example first file should have 

a@a.com

b@a.com

c@c.com

second file

a@a.com

b@a.com

third file

a@a.com

 

Can anyone help me on this. Thanks in advance.

 

 

 

Thanks,

Bharath.

1 ACCEPTED SOLUTION

Accepted Solutions
Seven Stars

Re: How to group records and send first record of group to online file and same for rest

Thanks for your reply. We got the solution for this.

Even though we got we will also try which you said.

 

Thanks,

Bharath

2 REPLIES
Nine Stars

Re: How to group records and send first record of group to online file and same for rest

Hi,

 

Please try below.

 

EmailSplit1.PNGEmailSplit2.PNGEmailSplit3.PNGEmailSplit4.PNGEmailSplit5.PNG

Regards,

Veeru Boppudi
Seven Stars

Re: How to group records and send first record of group to online file and same for rest

Thanks for your reply. We got the solution for this.

Even though we got we will also try which you said.

 

Thanks,

Bharath