Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
ODI Text to columns — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ODI Text to columns

Received Response
3
Views
2
Comments
in Data Integration 2 comments

Summary:

Looking for a text to columns function within ODI

Content (required):

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!