3 rows must go to a single record

My flat file has data having 4 rows for one record identified by first character. Like

A763478hdfjhgdf7634563hsjfhsdh
B763478yerty747875hdgfh
C763478 e78745874857hdjfd

Here A is identifier of first 4 column B for next 3 and C is for next 3 column of same record. How can I make a transformatin so that these 3 rows goes to a single record.

-Deb

[b]Question asked by visitor Debesh[/b]

hai ,

use router transformation to sepetate the records in different target table.

[QUOTE=v.ravindran;16552]hai ,

use router transformation to sepetate the records in different target table.[/QUOTE]
Ravi,

I Hope the answer that you have given is quiet mismatching to the Question.

Almost question is also in the similar way.... Need more clarity and description for the question. He is telling firstly 4 rows, then he wants to load 3 rows into 1 row.

Hey [B]guest[/B], can you update your question with some more info...?

Sanghala

Using expression and Aggregator transformation. we can achieve that task. If u have any doubt. Pls send the email to me (cme_prak@yahoo.co.in)