Unique id's missing

Hello,
Hope you are doing well!
In my file there are few numeric unique Id’s missing.
Is there any (node) way to generate new Id’s only for the missing ones and not changing the primary numeric Id’s.

Thanks you!

Are these IDs you’ve assigned and not Knime RowIDs? Also do they appear as Knime Missing Values, i.e. “?” or just blanks? A screenshot or preferably a data set would be helpful.

6 Likes

customer.xlsx (513.4 KB)

I’ve attached the file which I need to work on.
The customer’s id’s are missing from the data set and want to know the alternative can be done except removing it

hi @RajatG
my approach on the missing ID’s, assigning dummy ID.
missing:
image
existing:
image
KNIME_missing_MM.knwf (80.0 KB)

rgds
linux knime 5.1.x

4 Likes

Hello,
Thank you for your prompt response. I really appreciate your efforts for my query.

Regards,
Rajat

1 Like

Hello,
Thank you everyone for your prompt response. I really appreciate your efforts for my query.

Regards,
Rajat

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