How add a Static sequence of numbers column

Question
1

Hi, is it possible to add a new column with a static sequence of numbers?

2

Row Num transformation adds such

https://www.easydatatransform.com/help/20/mac/html/index.html?row_num.html

3

Thanks I used it but it has a dynamic behavior. If rows quantity in subsequent transformations vary, numbers vary too :neutral_face:

4

If you have a key field which is the master you can check the HASH transformation, maybe this gives what you need.

https://www.easydatatransform.com/help/20/mac/html/index.html?hash.html

5

I’m not sure what you mean. Can you give an example?

6

I need a sequence of numbers that are binded with other fields, once generated. Static. Don’t know if I was clear.

7

they will be part of the row once generated, and not vary changing other columns.

8

But why do you think that that a row number added once, does change later on? If you don‘t manipulate the value it will stick as every other field.

1 Like
9

I thought it was so but i couldn’t obtain what I searched. It seems that the values change in a manner that I can’t understand once firstly created.

10

Can you share what gave you pain and you had changes?

1 Like
11

Sorry, that still isn’t clear. We really need sample input(s) and the corresponding output you want.

1 Like