Hi Matthew,
To specify a column as a datetime or duration in a tabularTextDatastore, you need to first convert the column to the appropriate data type before creating the datastore.
Below are the steps to convert the "Time" column to a duration of seconds:
% Load the data into a table
mytable = readtable("C:/myfiles/mydata.csv");
% Convert the "Time" column to a duration of seconds
mytable.Time = seconds(mytable.Time);
% Create a timetable from the table
mytimetable = table2timetable(mytable, 'RowTimes', 'Time');
% Save the timetable as a MAT file
save("mytimetable.mat", "mytimetable");
% Load the timetable from the MAT file
mytimetable = load("mytimetable.mat", "mytimetable").mytimetable;
% Create a tabularTextDatastore from the timetable
ttds = tabularTextDatastore("mytimetable.mat", "ReadFcn", @load, "SelectedVariableNames", {'Time', 'WT1DCBusVoltage1', 'WT10ACCurrentAPhase'});
This will create a tabularTextDatastore that only includes the "Time", "WT1DCBusVoltage1", and "WT10ACCurrentAPhase" columns.
You can read more about the tabularTextDatastore, seconds and table2timetable functions from the following documentations: tabulartextdatastore Function, seconds Function, table2timetable Function.
Hope it helps!
Regards,
Gayatri Rathod
