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!

Split a sources column in two diferent columns in target

879095Apr 11 2012 — edited Apr 11 2012
Hi There

I'm having problems trying to figure out how to split a column. In Source I have a column with value like this "prod_ID prod_name", in the target table I have two columns one for product ID and other one to product name.

I tried with something like this

TABLE.PRODUCT <%=.split()[0]%>

Maybe it's useful the odiRef.getColList(), I suppose that function returns the value of the column, but I don't know how to use it.

Any idea?

Regards / Saludos.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2012
Added on Apr 11 2012
#business-intelligence-applications, #data-integrator, #system-management-and-integration
1 comment
220 views