I am facing a problem with concatinating multiple rows in order and storing in to a target table for particular records.
Pls help me. I need a procedure or any good thing. Below is my input sample data
|300||satya||2||gar near hot|
|300||satya||3||el baristha h|
|302||shee||2||w street hyde|
And Required Output is
|300||satya||gandhi nagar near hotel baristha hyderabad|
|302||shree||gachibowli new street hyderabad|
*I have millions of records with distinct EID's in Source.
I tried Recursive function but it's using more spool and also its not concatinating in order(Data should be cancatinated with the respect of Line_Num). So Iam thinking that recursive is not a good thing.
Pls share me If you have any Idea.