Logic help

[mahitham]

Hi,

Can any one please help me on below requirement.

I have the table like below with two fields . here one name contains multiple values like below

Input:

Name                  Value

Dataset                GH

Dataset                AB

Dataset                KL

Content               ahj

Content               jkl

Expected Output:

Name                  Value

Dataset             GH,AB,KL

Content           ahj,jkl

Can any one please help me to get the above expected output.

Thanks in advance

[NS]

Try this..
first dimension - AGGR(Name,Value)
second dimension - AGGR(Concat(Value,','),Name)

[StarinieriG]

Hi,

you could do this inside script:

NoConcatenate
Output:
LOAD
Name,
Concat(DISTINCT Value,',')
Resident Input
Group By
Name
;

or using name as dimension and Concat(DISTINCT Value,',') as expression