A case on talend for data integration

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. 

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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.