# Generate or Create UniqueID / KeyID / Primary Key

**URL:** <https://forum.knime.com/t/generate-or-create-uniqueid-keyid-primary-key/62539>\
**Category:** KNIME Analytics Platform\
**Created:** [February 24, 2023, 8:08pm UTC](https://forum.knime.com/t/generate-or-create-uniqueid-keyid-primary-key/62539 "2023-02-24T20:08:45Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![wisemanleo](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/w/a8b319/32.png) [@wisemanleo](https://forum.knime.com/u/wisemanleo)\
**Post date:** [February 24, 2023, 8:08pm UTC](https://forum.knime.com/t/generate-or-create-uniqueid-keyid-primary-key/62539/1 "2023-02-24T20:08:46Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![HansS](https://forum-cdn.knime.com/user_avatar/forum.knime.com/hanss/32/6979_2.png) [@HansS](https://forum.knime.com/u/HansS)\
**Post date:** [February 24, 2023, 8:45pm UTC](https://forum.knime.com/t/generate-or-create-uniqueid-keyid-primary-key/62539/2 "2023-02-24T20:45:47Z")

</div>

He @wisemanleo

Did you check the [RowID](https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.preproc.rowkey2.RowKeyNodeFactory2/) node?  
gr. Hans

---

<div class="post-metadata">

**Author:** ![wisemanleo](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/w/a8b319/32.png) [@wisemanleo](https://forum.knime.com/u/wisemanleo)\
**Post date:** [February 24, 2023, 9:12pm UTC](https://forum.knime.com/t/generate-or-create-uniqueid-keyid-primary-key/62539/3 "2023-02-24T21:12:38Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\
**Post date:** [February 24, 2023, 10:27pm UTC](https://forum.knime.com/t/generate-or-create-uniqueid-keyid-primary-key/62539/4 "2023-02-24T22:27:26Z")

</div>

@wisemanleo there is also this node

> **[GUID Generator – sjporter](https://hub.knime.com/sjporter/spaces/Public/latest/GUID%20Generator~_D5O4za6bToqQAfi)**
>
> A Globally Unique Identifier (GUID) generator for KNIME. This component is useful for creating a unique key that is not based on Row ID. This component will ap…

---

<div class="post-metadata">

**Author:** ![wisemanleo](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/w/a8b319/32.png) [@wisemanleo](https://forum.knime.com/u/wisemanleo)\
**Post date:** [February 25, 2023, 2:11am UTC](https://forum.knime.com/t/generate-or-create-uniqueid-keyid-primary-key/62539/5 "2023-02-25T02:11:52Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![denisfi](https://forum-cdn.knime.com/user_avatar/forum.knime.com/denisfi/32/83308_2.png) [@denisfi](https://forum.knime.com/u/denisfi)\
**Post date:** [March 2, 2023, 2:37pm UTC](https://forum.knime.com/t/generate-or-create-uniqueid-keyid-primary-key/62539/6 "2023-03-02T14:37:58Z")

</div>

Hi,

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

![image](https://forum-cdn.knime.com/uploads/default/original/3X/4/d/4d369024e6cc285e15a9d67d05efeb814e505a22.png)

And you can set up some preferences.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/5/9/59017aa1cdfe8e984f54615cd9e4aa95ee9b4aed.png)

I hope this help you,

Seeya,

Denis

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [May 31, 2023, 2:38pm UTC](https://forum.knime.com/t/generate-or-create-uniqueid-keyid-primary-key/62539/7 "2023-05-31T14:38:04Z")

</div>

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