Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
removing duplicates without using suppress duplicates
Migrateduser
Hello everyone, I have use the suppress duplicates and it works fine for string but in my case I have also duplicates in numbers (counts) which I have to remove, I just have to retain the original.
I have result like this:
group |owner| count
data1 | abc | 3
data1 | def | 3
data1 | ghi | 3
data2 | eee | 1
data3 | fff | 1
data4 | ggg | 2
data4 | hhh | 2
I have achieved this using suppress duplicates in column 'group':
group |owner|count
data1 | abc | 3
_____ | def | 3
_____ | ghi | 3
data2 | eee | 1
data3 | fff | 1
data4 | ggg | 2
_____ | hhh | 2
but when I use suppress duplicates in 'count' column it shows like this:
group |owner|count
data1 | abc | 3
_____ | def |___
_____ | ghi |___
data2 | eee | 1
data3 | fff |___
data4 | ggg | 2
_____ | hhh |___
the count for data3 is gone too using suppress duplicates in 'count' column because count from data2 and data3 are both '1'
What do I do now? how do I remove the duplicates that will not affect the next row?
Thanks in advance and more powers!
Find more posts tagged with
Comments
There are no comments yet