how to multiply by 100 in a line and not a column in a component tMap

Seven Stars

how to multiply by 100 in a line and not a column in a component tMap

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: how to multiply by 100 in a line and not a column in a component tMap

Seven Stars

Re: how to multiply by 100 in a line and not a column in a component tMap

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.