Hi, I have two indexes from two different sources, but I want to use them together, preferably in a table. index1 contains data on hardware units in a rack, with fields ESN (serial number) and UnitTemperature. index2 contains external temperature data, with fields Thermocouple (which are just numbered 1 to 8 ) and Temperature. Thermocouples 1-4 are at the back and 5-8 are at the front of the rack. I have a lookup table to get the number of the two thermocouples (front and back) closest to each unit from their ESN. Now what I want is to make a table with columns: ESN, Unit Temperature, Closest Front Thermocouple Temperature, Closest Back Thermocouple Temperature. Is there any easy way to do this? Thanks.
... View more