Can you match a column based on an approximate match

[Rachel Moring]

I have two data sets - one has depth values every 30' and the other has depth values every 100'. I am wondering if there is a way that I can have an associated value for the 100 depths applied to three consecutive values with the 30' depths.

[Fabian Duerr]

I see three options here:

Try to create a common column that you can use for the join by using a binning function on your time column. Make sure to use a transformation for this column, not just a simple calculated column. Otherwise you can't use the column for the join.

Make a full join of your tables. Create a calculate column for your condtion. Then add one more transformation to create final table by filtering to your condition.

Write a data function for the approximate or overlapping match. For more information check my answer in the following link:https://community.spotfire.com/questions/common-data-periods