Seven 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

Accepted Solutions
Forteen 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:

Hope this helps.

TRF

All Replies
Forteen 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:

Hope this helps.

TRF
Seven Stars

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

Thank you, it works well !

## 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.