Forum Stats

  • 3,827,605 Users
  • 2,260,798 Discussions


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 -

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,