I want to create a column with just sequential row numbers from 1 to the number of rows. What is the best way to do that? Thank you.
Use the Row Num transform. ;0)
1 Like
You can do the following
Create a simple column with the values you need like From and To
SequentailRowNumbs
1
100
and then use Sequence Transform to fill in the gap.
Above solution is, if you want to create a Sequence Column only and then use it for whatever purpose it was created.
But if you already have a data and you need to create Sequence in it, then follow what @Admin has suggested, use Row Num transform.
Transform file.
SequentailRowNumbs.transform (1.9 KB)
2 Likes