How to count from first unique value till the next unique value is encountered?

KNIME Analytics Platform
1

Hi everyone,
I am kind of new in KNIME. I am trying to make a data manipulation for my thesis.
I have the table below with author_ID and article_ID columns. I want to append indexing column to this table. I want to count the same article_IDs till the next different article_ID.

I tried something with aggregation nodes but couldn’t succeed. I kindly need your suggestions.

TABLE
author_ID article_ID indexing
11 1350 1
12 1350 2
13 1350 3
14 1350 4
15 1350 5
16 1922 1
17 1922 2
18 2661 1
19 2661 2
20 2661 3
21 2985 1
22 5182 1
23 5182 2

2

Look at Rank node

1 Like
3

Hi

See Repeating a Moving Aggregation (What are the options): Is similair problem / solution

gr. Hans

4

Thank you!

5

It worked. Thank you!

1 Like
6

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.