Is there a way to do a linear interpolation using a database feed and a lookup table? We receive continuous data from our onsite monitoring, and we need to lookup a reference table(see below) to get an output. The value of the continuous data references the first column and then interpolated output based on the second column is produced.
For example, if we receive a value of 590.10ft, we would like to get an answer of ~13.4cfs. We currently have excel spreadsheets and some old Python code that can produce this but is this possible using TOS?
OK, well this may work for you.....
You can plug that code into a Talend routine and use to carry out your calculation
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Accelerate your data lake projects with an agile approach