topic Re: Auto Increment String ID in Talend Studio

Auto Increment String ID

Anonymous — Tue, 02 Jul 2019 06:16:40 GMT

I have orderNo as VarChar Autoincrement ID. For example, the last inserted record has order No "0000323". The next inserted record will be 0000324 accordingly. How can I implement this? In table, it doesn't store ID as integer but only as GUID. How can I know the last inserted orderNo?

Re: Auto Increment String ID

Anonymous — Tue, 02 Jul 2019 20:44:56 GMT

Hi,

Why don't you store the maximum value of last inserted data to a control table? During next run, pick the value from this control table and use the starting value as last value+1.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Auto Increment String ID

Anonymous — Mon, 08 Jul 2019 10:37:08 GMT

There is running number table to record last inserted number. I just retrieve number from this table. And it solve the problem.