Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this..
first dimension - AGGR(Name,Value)
second dimension - AGGR(Concat(Value,','),Name)
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