topic Re: Multiply by 100 in a component tMap in Talend Studio

Multiply by 100 in a component tMap

Anonymous — Tue, 24 Apr 2018 12:43:53 GMT

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 — Thu, 26 Apr 2018 05:01:39 GMT

You could use IF condition, something like:

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

(of course same for all columns)

TRF — Thu, 26 Apr 2018 06:56:38 GMT

Anonymous — Thu, 26 Apr 2018 08:26:01 GMT

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

Thank a lot.