SAP HANA Calculation view concatenating

[former_member452749]

Hi all,i need your help to understand how to solve the following problem :

I suppose that i have an order (AUFK-AUFNR) and some operations description for it :

AUFNR   VORNR   LTXA1

1              10            text ltxa1 10

1              20            text ltxa1 20

1              30            text ltxa1 30

The result should be aggregated  by AUFNR on a single row :

AUFNR   LTXA1

1              text ltxa1 10 , text ltxa1 20 , text ltxa1 30

This has to be done inside a calculation view,but i don't know how...could you have some advices for me,please?

Have i to use cursor or loop on result set?

Thanks in advance.

Ciao.

Dario.

[Former Member]

Hi Dario,

I applied the following example using a cursor. This works fine for me on a small set.

Concatenate rows (sql server 2000) - Stack Overflow

Alternative methods to the cursor are explained below, but I did not use these myself.

Concatenating Row Values in Transact-SQL

hope this helps,

Scott