Skip to main content
Question

How to split the value in a particular column into columns? Need help with this query.

  • September 17, 2022
  • 6 replies
  • 22 views
P
Level 7

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

    6 replies

    G
    Level 12

    STRING_SPLIT

     

    https://docs.celonis.com/en/string_split.html

     

    Intro = STRING_SPLIT("NAME",'-',0)

     

    HTH

    sarina.somme
    Level 4
    Forum|alt.badge.img+11
    • sarina.somme
    • Level 4
    • October 13, 2022

    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?

    G
    Level 12

    Hmmm, is the column of type string? Otherwise should be some bug, because STRING_SPLIT is still in the documentation

     

    sarina.somme
    Level 4
    Forum|alt.badge.img+11
    • sarina.somme
    • Level 4
    • October 13, 2022

    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. 

    sarina.somme
    Level 4
    Forum|alt.badge.img+11
    • sarina.somme
    • Level 4
    • October 13, 2022

    I used the Function SPLIT_PART from the Vertica documentation and now it's working.

    G
    Level 12

    I used the Function SPLIT_PART from the Vertica documentation and now it's working.

    👍

    Community Code of ConductAccessibility statement