Hi All,
I need some help in doing a calculation based on two separate data sets. First data set has different values in different columns. And in 2nd table, there are three main character columns. Now based on a these three columns and based on matching other conditions, we need to perform subtraction operation in first table and results need to be store in a new column in first table.
Something like this -
Names Default to here(1);
dt1 = Data Table("Dataset");
dt2 = Data set("Realtime");
//Create R1 column in Table 1.
// In Table 1, Somehow find the matching values for board and sensor from Table 2 and perform the calculation from different columns
// Board == M & Sensor == 2 and C11 & C8 is not missing then R1 = C11 - C8, otherwise leave it empty
// Board == M & Sensor == A and C11 & C10 is not missing then R1 = C11 - C10, otherwise leave it empty
// and so on.
//Create R2 column in Table 1 and then calculate values
//
// Probably in first loop we can generate 8 columns from R1 to R8 and then calculate each value of these columns somehow.
Any help?
