A case on talend for data integration

[Anonymous]

Dear folks

 i have an id column that value are 1, 01, 001. if i want to move data into database than how can i achieve 001, 001, 001.

kindly share your valuable information. 

[TRF]

So I suppose Id is String datatype else you cannot have leading 0.
Try this:
(1000 + row1.id).substring(1)

[vboppudi]

Hi,

Please try below.

Regards,