Rows are getting duplicated due to 1 column

[Vinay_47]

I have two columns named Id and approvers

1st row Id no 1 has values David;Musta;

2 nd row Id no 1 has values Vinay;

3rd row Id no 1 has values Kronid;

I want the outcome as single line and Id should have only 1 and Approvers values should be David;Musta;Vinay;Kronid 

can someone help me on this please

[ayman_salem · Accepted solution]

Define the following variables:

v_approvers:  =(Previous(Self; ([Id]))+([approvers]))

v_approvers_max:  =NoFilter(Max([v_approvers])) ForEach ([Id])

v_status:   =NoFilter(If ([v_approvers] = Max([v_approvers]) In ([Id])) Then "D"; All )

then hide the coulmn "approvers" and apply the filter (v_status equal to "D") to the table

...

hope it helps

[ThorstenHoefer · Accepted solution]

Hi,

have you checked STRING_AGG?

    WITH +f AS (
     SELECT DISTINCT currency , carrid FROM sflight
    )
    SELECT f~currency AS cur
         , STRING_AGG( f~carrid , ',' )  AS car
    FROM +f AS f
    GROUP BY f~currency
    INTO TABLE (lt_msg).


    out->write( lt_msg ).