Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to remove duplicate data in Field

Hi Experts,

I have a meeting type code is below...

 

1X1
GRP
3X1
2X1
CCL
Lunch
Dinner

In that data lot of duplicates is there

How to remove the duplicate in a Meeting type code.

Thanks

14 Replies
Anonymous
Not applicable
Author

Hi Anil...

I am trying Calculated Dimension but i need a count of meetings.

Anil_Babu_Samineni

Why dont u tried from expression?

Anyway, try this

If(Aggr(count({<[Event Type]={'Non Deal Management','Conference','Field Visit','Field Trip','Other GCA','IMG - Investor Reverse Inquiry'}>} distinct [Meeting Id]),[Client name]), [Client name])

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

expression it showing wrong...

Anil_Babu_Samineni

Will you able to provide sample application?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
MarcoWedel

what is your expected result?