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.
Solved! Go to Solution.
Hi @DataPsycho.
Would you like just to add an incremental number? in that case you just need to use the Record ID tool.
I see, It is new in version 11.
thanks, I was having trouble finding that tool
[Row-1:RowCount] + 1
I added Record ID tool at the front-end, before the Transpose. But I would like to see the Record ID value at teh diff outputs of the join tool, but it doesn't pass thru the Record ID - don't know why.
Guess I don't fully understand Record ID ?