Generate a Unique ID/GUID for All Records During Excel to SQL Table Insertion in KNIME

[San_07]

I’m inserting Excel data into a SQL table using KNIME Analytics Platform. I need to generate a unique ID/GUID to insert along with the Excel data, where the same unique ID/GUID is applied to all records. I don’t see guid generator in knime analytics platform

[mlauber71]

@San_07 depending on your database you can create such an id within

Errors writing KNIME string to PostgreSQL uuid field

A solution could be something like this. You upload the file with the UUID into a emporary table and then insert it into the target table [image] The CAST() command would convert it into a uuid [image]

Or you can use this component

GUID Generator – sjporter