Generate or Create UniqueID / KeyID / Primary Key

After reading data from CSV (or perhaps any input node), I’m looking to generate a new column with a unique ID, key ID, or a primary key for the dataset. The reason for this is to allow for the data table to be split and re-joined downstream after some work on select columns.

I was surprised not to find coverage on this topic already, so I’ve either not searched enough, searched the wrong terms, or I’m missing something blatantly simple. I realize that all three are my problem, and I apologize in advance. Any guidance extended would be sincerely appreciated.

He @wisemanleo

Did you check the RowID node?
gr. Hans

2 Likes

Thanks @HansS, alas - thank you. I think that should work, if I perhaps leave the first box unchecked, while checking the second box to create a new column to hard code a new RowID. Thank you.

1 Like

@wisemanleo there is also this node

1 Like

Excellent - I will check this out as well - good to have options with keyID’s.

Hi,

You can use the RowID node to generate new IDs for your table.

image

And you can set up some preferences.

I hope this help you,

Seeya,

Denis

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