Values of a line multiply by 100 (And not columns, just line)

Seven Stars

Values of a line multiply by 100 (And not columns, just line)

Hello

 

I have 2 lines and several columns. All are in double in the fileinputExcel.

List1   Column A        Column B          Column C

Number    145,25               254,12           54,94

%               0,331                0,154             0,504

 

I only want to multiply the line with % by 100. So, in the fileOutputExcel, i want see : 

List1   Column A        Column B          Column C

Number    145,25          254,12               54,94

%               33,1              15,4                 50,4

 

I tried to use the component tMap but it multiply all the columns (Number and %).

 

I don't how to do

 

Thanks in advance

Thirteen Stars

Re: Values of a line multiply by 100 (And not columns, just line)

Seven Stars

Re: Values of a line multiply by 100 (And not columns, just line)

Yes, i know. I had a little problem with posts.

Thank a lot.

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.