Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Concatenation according to condition

660366Mar 31 2010 — edited Apr 5 2010
Hi All,

I ahve to concatenate the rows based on other row values....

example:

Col1 Col2

A X
A Y
B Z
B Y

needs to load into target table as:

Col1 Col2

A X:Y
B Z:Y

concate col2 accoring to col1


Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2010
Added on Mar 31 2010
#business-intelligence-applications, #data-integrator, #system-management-and-integration
5 comments
1,673 views