Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rakeshkumar1890
Creator
Creator

Distinct result on dimension

Hello everyone,

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

Table :

Iddiscription
100abd
100abd
100 
200uyt
200 
200 
300 
300 

 

Result:

Iddiscription
100abd
200uyt
300 

 

Need this result on table dimension.

Thanks to everyone.

 

  

6 Replies
pradosh_thakur
Master II
Master II

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
];

Learning never stops.
rakeshkumar1890
Creator
Creator
Author

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

 

Chanty4u
MVP
MVP

try this

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

rakeshkumar1890
Creator
Creator
Author

Thanks @Chanty4u , Its not working 

Taoufiq_Zarra

@rakeshkumar1890 

dimension : ID

Measure : =concat(distinct discription,'')

output:

Taoufiq_Zarra_0-1607598097205.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
gp_oconnor
Partner - Contributor III
Partner - Contributor III

First dimension in table: Id

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