Six Stars

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

1 ACCEPTED SOLUTION

Accepted Solutions
Thirteen Stars TRF
Thirteen Stars

Re: how to multipy by 100 a value of a line : tMap

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:Capture.PNG

Hope this helps.

 

 


TRF
2 REPLIES
Thirteen Stars TRF
Thirteen Stars

Re: how to multipy by 100 a value of a line : tMap

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:Capture.PNG

Hope this helps.

 

 


TRF
Six Stars

Re: how to multipy by 100 a value of a line : tMap

Thank you, it works well !