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

[javvaji]

 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.

[Anonymous]

@nthampi

Apologies, I saw this after I wrote my post and thought see if anyone can help.

[vboppudi]

Hi Shaf,

Please try below job. I used limited attributes for process. 

Used tFilterRow to restrict "I" records.

Used tMap to restrict number of attributes from source.

And connected the tMap output to tFlowtoItterate.

connected tfolowtoiterate to tFxedFlow and created number of attributes

Then connected to output file.

Regards,