Combine two tables based on date time

I have a table A with a datetime (Year, month day and time) and a table B with a datetime(year month day)
Now I have to combine those two tables with each other based on the date. I have to check what date will match from table A to table B and the that index of table B.
For now I have this script, but it doesn't work
check = dir('*.xls');
weatherYear = readtable("/Users/diontheunissen/Documents/Smart_Driver/RawData/weatherYear.xlsx", opts, "UseExcel", false);
Date = datetime(weatherYear.Aug2020);
name = fullfile(check(1).folder, check(1).name);
Ritten = readtable(name, opts, "UseExcel", false);
Datum = datetime(Ritten.Starttijd);
Datum.Format = 'dd-MMM-yyy';
Ritten.Starttijd = Datum;
t1 = datetime(Datum,'InputFormat','yyyy-MM-dd');
t2 = datetime(Date,'Format','yyyy-MM-dd');
[logical_Index ,index] = ismember(t1,t2);
A =
B=
Anyone who can help me?

답변 (1개)

Scott MacKenzie
Scott MacKenzie 2021년 8월 3일

1 개 추천

TT1 = table2timetable(A);
TT2 = table2timetable(B):
TT3 = synchronize(TT1, TT2);

댓글 수: 2

Dion Theunissen
Dion Theunissen 2021년 8월 3일
Check my update, maybe it will be a bit more clear
Peter Perkins
Peter Perkins 2021년 8월 5일
Scott's answer is the right way to do this, although you may want to be more xplicit and specify the target time vector and the method. But I think the defaults do what you want.

댓글을 달려면 로그인하십시오.

카테고리

도움말 센터File Exchange에서 Timetables에 대해 자세히 알아보기

제품

릴리스

R2021a

질문:

2021년 8월 3일

댓글:

2021년 8월 5일

Community Treasure Hunt

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

Start Hunting!

Translated by