Skip to Content
author's profile photo Former Member
Former Member

Split function in SDI

Hi Expert,

i have following record in one of my columns. i want to split it into individual rows. Please let me know any trick in SDI

Current table

SR NO COUNTRY 1 USA, CANADA, INDIA,

Expected output in SDI

SR NO COUNTRY 1 USA 1 CANADA 1 INDIA

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jun 22, 2016 at 04:30 AM

    this functionis is there in BODS , but not there in SDI, as per as I know. you need to implement function for this.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 25, 2016 at 09:04 AM

    How would you do that in Data Services? One option would be turn the string into XML and then convert it into a nested structure which you then unnest. The other option would be to split the string into multiple columns and then use the pivot transform to turn the columns into rows.

    The second option should work in SDI as well - have not tried it out myself yet, though.

    I would use the substr_regexp() Hana function as mappings in three columns, to get the first, second and third value in each column.

    And then use the unpivot transform (unpivot in SQL = Pivot in BODS).

    That should work...

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.