topic A case on talend for data integration in Talend Studio

A case on talend for data integration

Anonymous — Thu, 03 May 2018 18:27:24 GMT

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 — Thu, 03 May 2018 18:45:48 GMT

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

vboppudi — Thu, 03 May 2018 18:59:17 GMT

Hi,

Please try below.

Regards,