"Anyone please? Loop Attributes? -

MacPhotoBiker

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:

客户	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!

MacPhotoBiker

The most promising operator seems to be the "Loop Operator".

Here's how my table looks like currently:

客户	Article	Counter
C1	A1	1
C1	A1	1
C1	A1	1
C1	A2	1
C1	A2	1
C2	A1	1
C2	A2	1

I want the operator to integrate "Counter" for every different Customer-Article combination. After the operator, the table should look like this:

客户	Article	Counter
C1	A1	1
C1	A1	2
C1	A1	3
C1	A2	1
C1	A2	2
C2	A1	1
C2	A2	1

The best I came up with is this process, but it's not working:

<宏/ >

And here's the data as csv:
客户,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!