Finding the Closest Value to an Input Value from a Table Column

I have the below code that finds a value that is less than or equal to RESULTS.Vertical_Heel_Trajectory_at_HS1(1,1) in the following table column RESULTS.Inverse_Kinematics_Tables{1,1}.(ab{1,1} and names it RESULTS.Second_HS_Thresholding.

The issue I have is that values are sometimes not always less than or equal to, but is very close. I would therefore like to change the code so that it picks up the closest value to RESULTS.Vertical_Heel_Trajectory_at_HS1(1,1) value.

I have also attached a figure to illustrate this point further.

RESULTS.Second_HS_Thresholding= find(any(RESULTS.Inverse_Kinematics_Tables{1,1}.(ab{1,1})<= RESULTS.Vertical_Heel_Trajectory_at_HS1(1,1),2));

Answer 1

[Cris LaPierre]

Find the minimum of the absolute value of the difference.

[val,idx] = min(abs(x-y))

You can read more about what the outputs are here.

[Jake Bowd]

Thanks, Cris.

I have now spent some time reading the documentation on Min. It would appear it is the right approach to take, although not using the 'abs' function.

However, I cannot find a way to put a condition into the equation such that the following finds the minimum value after a specified row number, for example row 40.

[val,idx] = min(x);

[Cris LaPierre]

You will need to use abs if you want the closest value - above or below the threshold. If you only want to find a subset of data (a new requirement not mentioned in your OP), you need to pass in the subset of data to min.

[val,idx] = min(x(40:end));