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]
Re: 3 rows must go to a single record
hai ,
use router transformation to sepetate the records in different target table.
Re: 3 rows must go to a single record
[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
Re: 3 rows must go to a single record
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)