Eg: for a column "NAME" one of the value is "HELLO-WELCOMETO-CELONIS"
I want this to be split to 3 columns..
Intro: HELLO
Greeting: WELCOMETO
Tool: CELONIS
As 3 different columns
CHARINDEX giving error that this function does not support.
Page 1 / 1
When I want to use the function STRING_SPLIT I get the following error:
Execution error: Function STRING_SPLIT is not supported
Does anyone know what could be the reason for this?
Hmmm, is the column of type string? Otherwise should be some bug, because STRING_SPLIT is still in the documentation
Yes the column is VARCHAR(100), so this shouldn't be a problem. I also wonder why I get this error, because I had taken this function from the documentation.
I used the Function SPLIT_PART from the Vertica documentation and now it's working.
I used the Function SPLIT_PART from the Vertica documentation and now it's working.
👍
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.