how to multipy by 100 a value of a line : 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

[TRF · Accepted solution]

You may use a tJavaRow for this case:

output_row.List1 = input_row.List1;
if(input_row.List1.equals("%")) {
	output_row.ColA = input_row.ColA * 100;
	output_row.ColB = input_row.ColB * 100;
	output_row.ColC = input_row.ColC * 100;
}
else {
	output_row.ColA = input_row.ColA;
	output_row.ColB = input_row.ColB;
	output_row.ColC = input_row.ColC;
}

Using a tMap, you have to use the ternary notation:

Hope this helps.

[Anonymous]

Thank you, it works well !