Seven Stars

A case on talend for data integration

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. 

2 REPLIES
Forteen Stars TRF
Forteen Stars

Re: A case on talend for data integration

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

TRF
Nine Stars

Re: A case on talend for data integration

Hi,

Please try below.

lpad1.PNGlpad2.PNG

Regards,

Veeru Boppudi