Hello Rabia,
To acheive the desired workflow, follow these steps:
- Read the contents of XLSX files into tables, using the "readtable" function.
T1 = readtable('firstFile.xlsx');
T2 = readtable('secondFile.xlsx');
- Append an additional column to the table corresponding to the second XLSX file, inorder to store the time values.
T2.Time = strings(height(T2),1);
- Map the names in both the tables to find the corresponding time values.
for i = 1:height(T2)
idx = find(strcmp(T2.Person{i}, T1.Name));
if ~isempty(idx)
T2.Time(i) = T1.Time{idx};
else
T2.Time(i) = ""; % "Not Found"
end
end
disp(T2);
To better understand the above workflow, refer to the following documentations:
