Distinct result on dimension

[rakeshkumar1890]

Hello everyone,

I am trying to get distinct result but as below result:

Table :

Id	discription
100	abd
100	abd
100
200	uyt
200
200
300
300

Result:

Id	discription
100	abd
200	uyt
300

Need this result on table dimension.

Thanks to everyone.

[pradosh_thakur]

Try this

load Id, SubField(discription,',') as discription;
load Id, concat(distinct if(len(trim(discription))>0,discription),',') as discription
group by Id
;
load * inline [
Id,discription
100,abd
100,abd1
100,
200,uyt
200
200
300
300
];

[rakeshkumar1890]

Thanks @pradosh_thakur  for idea but I need this on expression not an script.

[Chanty4u]

try this

=only(AGGR(SUM(DISTINCT Id),discription))

[rakeshkumar1890]

Thanks @Chanty4u , Its not working 

[Taoufiq_Zarra]

@rakeshkumar1890 

dimension : ID

Measure : =concat(distinct discription,'')

output:

[gp_oconnor]

First dimension in table: Id

Second dimension in table: =Aggr(MaxString([discription]),Id)