The Altair Community and the RapidMiner community is on read-only mode until further notice. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.
Options
"Anyone please? Loop Attributes? -
![MacPhotoBiker](https://us.v-cdn.net/6030995/uploads/defaultavatar/nCCNNSPK1YM69.jpg)
![](https://s3.amazonaws.com/rapidminer.community/vanilla-rank-images/contributor-16x16.png )
Hi,
I'm trying to identify the first three orders when a particular customer purchased a particular product. The "integrate" operator could help to put a counter in each record, but I don't know how to reset it based on certain conditions (like "New customer and new article"). Here's what I try to achieve:
I'm hoping somebody could point me in the right direction.
Thank you!
I'm trying to identify the first three orders when a particular customer purchased a particular product. The "integrate" operator could help to put a counter in each record, but I don't know how to reset it based on certain conditions (like "New customer and new article"). Here's what I try to achieve:
Customer | Article | Counter |
C1 | A1 | 1 |
C1 | A1 | 2 |
C1 | A1 | 3 |
C1 | A2 | 1 |
C1 | A2 | 2 |
C2 | A1 | 1 |
C2 | A2 | 1 |
I'm hoping somebody could point me in the right direction.
Thank you!
Tagged:
0
Answers
Here's how my table looks like currently:
Customer,Article,Counter
C1,A1,1
C1,A1,1
C1,A1,1
C1,A2,1
C1,A2,1
C2,A1,1
C2,A2,1
C3,A3,1
I'd really appreciate somebody could help me out.
Thanks a lot in advance!