Forum Stats

  • 3,827,605 Users
  • 2,260,798 Discussions
  • 7,897,313 Comments

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 - 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

Tagged: