Auto Increment String ID

[Anonymous]

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? 

[Anonymous]

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 🙂

[Anonymous · Accepted solution]

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