Hi all,
Very new to Rapidminer!
I am needing to add a column into my table that runs a distinct count.
This is a sample of my table currently:
CaseNumber |
Date |
1A |
1/1/2015 |
1A |
1/2/2015 |
1A |
1/2/2015 |
2A |
2/1/2015 |
3A |
3/1/2015 |
2A |
4/1/2015 |
The Distinct Count would perform a distinct count on Case Number so:
CaseNumber |
Date |
DistinctCount |
1A |
1/1/2015 |
1 |
1A |
1/2/2015 |
0 |
1A |
1/2/2015 |
0 |
2A |
2/1/2015 |
1 |
2A |
3/1/2015 |
0 |
3A |
4/1/2015 |
1 |
Basically I just want to count how many unique case numbers there are.
So casenumber 1A occurs 3 times, but it's still just the 1 case number.
Same thing for casenumber 2A, it occurs twice, but still just the 1 case number.