Skip to Main Content

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!

Text to Columns function in ODI

Hello, We're migrating from Alteryx to ODI. The Alteryx tool has a very straight forward "Text to Columns" function that allows a user to take the contents of one column, and split it into multiple columns based on a specified delimiter. See Alteryx Documentation here - https://help.alteryx.com/2020.2/TextToColumns.htm
What is the equivalent function/transformation in ODI? If there isn't a built in function like this, what is the best way to handle this very common operation? Is there any documentation about how to perform this operation?
Thank you,
Brian

Comments

Post Details