How to add Record # as a Column in Alteryx?

Hi,

I have a table for example:

Name	Active	StartDate
a	0	1990-19-02
a	1	1990-20-05
b	1	1990-20-05
...	...	...

I want to add a new column to include the record # as RecordID. I tried with generate row tool. But it replicating with respect to the row and condition expression. I also can not delete condition expression. The result from generate row tool with RowCount <= 2 condition expression:

Name	Active	StartDate	RowCount
a	0	2016-11-07	1
a	0	2016-11-07	2
a	1	2016-11-25	1
a	1	2016-11-25	2
...	...	...	...

Or I do not know how to use it may be.

Preparation

Accepted answers

mborriero

Hi @DataPsycho.

Would you like just to add an incremental number? in that case you just need to use the Record ID tool.

MarqueeCrew

You will use a multi-row formula tool as:

Create RowCount (byte or int)

Group By = [Name]

Formula =
Row-1_RowCount + 1

Please note that my expression is approximate. I'm answering from my phone.

When you group by name, the problem almost solves itself with the tool. Adding one to the previous row starts you off with 1 for each new Name and keeps adding one.

Cheers,

Mark

All comments

mborriero

Hi @DataPsycho.

Would you like just to add an incremental number? in that case you just need to use the Record ID tool.

MarqueeCrew

DataPsycho

I see, It is new in version 11.

jackieheer

thanks, I was having trouble finding that tool

garthn555

[Row-1:RowCount] + 1

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703