Multiply by 100 in a component tMap

[Anonymous]

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

[Anonymous]

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

[vapukov]

You could use IF condition, something like:

row1.List1.equals("%")?row1.ColumnA*100:ColumnA

(of course same for all columns)

[TRF]

Same as https://community.talend.com/t5/Design-and-Development/how-to-multipy-by-100-a-value-of-a-line-tMap/...

[Anonymous]

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

Thank a lot.