topic Re: Calculating values using Linear Interpolation with two input files using Tmap and tJavaRow in Talend Studio

Calculating values using Linear Interpolation with two input files using Tmap and tJavaRow

Anonymous — Thu, 15 Mar 2018 10:10:50 GMT

Hello,

I have two input files, one of them is csv and the other one is Excel, they have different schemas.

I tried to use a Tmap to filter and get the columns that I need from both files and put them into two different outputs.

And now I need to do a linear interpolation based on two columns from the first file (csv) and one column from the second file (Excel), I already have the algorithm which requires using a loop and conditions (if, else..).

I don't know if I could do this in the Tmap, or I should use another component.

I found the component tJavaRow but I don't know how to use it because my Tmap has two outputs, would tJavaRow be able to read both of them in order for me to do the linear interpolation ? Is there another solution ?

Thank you.

Re: Calculating values using Linear Interpolation with two input files using Tmap and tJavaRow

Anonymous — Mon, 19 Mar 2018 03:09:54 GMT

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

Re: Calculating values using Linear Interpolation with two input files using Tmap and tJavaRow

Anonymous — Mon, 19 Mar 2018 09:18:13 GMT

After using a Tmap with the CSV file, I have two columns :

A (pourcentage)

B (duration)

After using a Tmap with the CSV file, I have many columns but the one I need to work with is :

C (duration)

And the one I need to fill is :

D (pourcentage)

For each value in my C column : x , I need to do an linear interpolation to find y (its pourcentage), which means find x1 in B as x > x1 and the next value x2, and their y1 et y2 from column A .

Once I have x1, x2, y1, y2, I can apply this :

y = (y2 - y1) * (x-x1) / (x2 - x1) + y1