Interpolated Table Extractor

Perform a lookup for a numeric value N against a two-dimensional table, returning a resultant one-dimensional table

The returned table is based on the interpolated value of N within the specified key column, such that the values returned for each column are also interpolated based on the numeric position of N between the keys found either side of N, or the single row if N is an exact match for a key.

The table must contain only numeric columns. They key column may be given any name, but the value columns must have numeric names, as these will form the key column of the returned table

e.g.
X 2 4 6 8
10 35 40 45 50
20 40 45 50 55
30 45 50 55 60
40 50 55 60 65

A lookup for X=20 would return the following table:
|Key|Value|
|2|40|
|4|45|
|6|50|
|8|55|

A lookup for X=15 would return the following (interpolated) table:
|Key|Value|
|2|37.5|
|4|42.5|
|6|47.5|
|8|52.5|
because 15 is mid way between 10 and 20

This table can then act as a lookup table with the Interpolated Value Lookup component, to return an interpolated single value from this table.

Input ports

1. Type: Table
   Input Table
   Table containing a numeric columns, including a lookup key and multiple value columns each with a numeric column name

Output ports

1. Type: Table
   Extracted Table
   An extracted lookup table, interpolated based on the value supplied as the key