Lookup values in ranges of a table and copy a corresponding output value in another table

5 views (last 30 days)
Hi,
I'm trying find 'Val' value from table A given by Lap number in table B from minimum of first 3 rows coresponding to each lap in table A (with no sorting).
The answer would be in Table B:
Lap Val
1 1
2 0
5 0
Thanks.

Accepted Answer

Voss
Voss on 22 Aug 2022
A = load('A')
A = struct with fields:
Events: [104×2 table]
B = load('B')
B = struct with fields:
Events: [3×1 table]
[~,idx] = ismember(B.Events.Lap,A.Events.Lap);
result = A.Events(idx,:)
result = 3×2 table
Lap Var ___ ___ 1 1 2 0 5 0
  11 Comments

Sign in to comment.

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Tags

Products


Release

R2021b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!