Generate extra columns and its values based on two tables.

[#1]

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?

[#2]

Hi HSS

I'm not sure the idea is what your want.

IMO, you could Inner Join the 't1' & 't2' which indexes are 'Board' & 'Sensor'. Then got a 't3'.

In 't3', create Col(R1) with formula(if(condition1&2&3&4, R1=C11-C8, else "Empty").

B.R.