topic Re: Creating GUID in Talend Studio

Creating GUID

Anonymous — Mon, 04 Nov 2019 07:44:02 GMT

Hi, I am new to Talend open studio for Data Integration and have a question that I hope some of your experts will be able to assist me with.

How to create GUID? What function do I need to use? Do I need to add a new column, which is ID? Thank you in advance

manodwhb — Mon, 04 Nov 2019 08:47:31 GMT

@hahahachum_ , GUID is kind of surrogate key? if yes you can generate using below function in tmap.

Numeric.sequence("s1",1,1)

Anonymous — Tue, 05 Nov 2019 01:03:53 GMT

I'm using "(java.util.UUID.randomUUID()).toString() " at tMap. the result as below:

How can i get string GUID? example: 0A09A860-A9A2-4539-3B3F-08D5924FE3AF

manodwhb — Tue, 05 Nov 2019 09:14:59 GMT

@hahahachum_ ,you can generate based on columns using tAddCRCRow,can you check that component is works for you.