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

Concatenate Data in One column

Hi,

I have a requirement to concatenate Text in one Column.

Col A (Key) Col B Col C (Text )

101 203 ABC

102 203 DEF

103 203 GHI

I want one row with Text in it.

101 203 ABCDEFGHI

102

103

How would I achieve this in SQL Script Procedure? Sample code ideas would be very helpful.

thanks!

@ak

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jan 04, 2014 at 10:54 PM

    Use a generated always statement.

    GENERATED ALWAY AS concat(A,B)

    Add a comment
    10|10000 characters needed characters exceeded

    • You are drip feeding me information... so you have a scenario with ERP replicated to HANA via SLT.

      You want a view exposed to SAP BO which has the first row of the table.

      In addition you want one column appended to that view with the concatenation of all the values in one column.

      Is that correct? If so can you paste your DDL? Thanks!

      John

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.