401891_en-US

liliconcom

Compare 2 tables and retreive relevant rows from one table based on the other.

I have 2 tables.

Table 1:  Timestamp (for one whole year in 15 minute intervals),i1,i2,i3,p1,p2,p3,p4 (and other 182 columns- which are not necessary here)

Table 2: Year, Month, Date, StartTime, EndTime ( StartTime and EndTime is in the format- h:m am/pm)

I would like to select (all 182 columns and) only the rows in table1 which lies between StartTime and EndTime of Table2  and make a subset.

How can I accomplish this 1) using point and click method- Like Joins and using Select row where.... and 2) JSL

 

Data TableScriptingRe: Compare two tables and retreive relevant rows from one table based on the other.I am not finding your description of your data tables clear enough to allow me to see exactly what their structures are. Could you please provide a few sample rows and columns for each of the data tables. That would really be helpful.