Error in Joining multiple date time duration id date is in cell Array

I am working on time series data. I am joining multiple time duration data . I need help, If duration is in cell array then I am unable to join the time series .

I am getting the following error

Error in matlab.internal.tabular.private.numArgumentsFromSubscriptRecurser (line
7)
n = numArgumentsFromSubscript(a, s, ctxt);

Error in tabular/numArgumentsFromSubscript (line 97)
    sz =
    matlab.internal.tabular.private.numArgumentsFromSubscriptRecurser(x,s,context);

Error in get_fieldnames (line 33)
            structtable.Date = duration(structtable.Date.Hour,
            structtable.Date.Minute, structtable.Date.Second);  %extract h/m/s
            and make that a duration.

Error in MainFcn (line 22)
[joinedtimetable]       = get_fieldnames(Content);

I have added work bench. Please find the attachment. Please provide the correct file path.

[Adam Danz]

Given the 10 files you provided, once they are added to the Matlab path, how do we recreate the problem?

Please proivde the code we can execute to recreate the problem.

[Guillaume]

What is the class and size of

structtable
structtable.Date

when the error occurs?

Completely unrelated and very minor but why the brackets around joinedtimetable in

[joinedtimetable]       = get_fieldnames(Content);

They don't do any harm but are completely unnecessary. After all, you don't have brackets around errorMessage in

errorMessage = sprintf('Error: file not found:\n\n%s', fullFileName);

so why there?

[Life is Wonderful]

Hi Adam ,

Once you extract the Issue_vmec.zip,

Please proivde the code we can execute to recreate the problem

Run file : MainFcn.m

Please add path manually from your PC [your *.zip file extract location]

Input filename is embedded in the *.zip itself. You should be able run the code outofbox.

Note - Error is observed when Test2 & Test3 is executed. Test1 is good case ( sample example)

Hi Guillaume

Question - when the error occurs?

class(structtable) is 'table'
class(structtable.Date) is 'Unknown'. We get the  error for line

Error in get_fieldnames (line 33)

structtable.Date = duration(structtable.Date.Hour, structtable.Date.Minute, structtable.Date.Second);  %extract h/m/s and make that a duration.

Sure, I will adapt the code as per your inputs.

Thank you very much!!

Answer 1

[Adam Danz]

In Test2, the table is not being read in correctly. The image below is the result of line 36 in get_vmlog.m. As you can see, the datetime values are cell arrays of strings.

If you look at the content of vmlogLATEST, it's qualitatively different from uiLATEST which is read in correctly. I guess this is why you have two different functions to read in the data.

Sample of uiLATEST

Sample of vmlogLATEST

So, you'll need to adapt get_vmlog() to use similar logic as you're using in get_ui() to read the datetime values.

Create vector of datetime from cell array of string values

To convert the Date values shown in the first screen shot image above to datetime values, add these two lines of code to your get_vmlog.m file after readtable().

I'm guessing you want to convert {'[0616/104015]'} to 10:40:15 following the logic of your previous questions.

Content.vmlog = readtable(filename, opts);

% convert cell array of time strings to datetime
timeStr = regexp(Content.vmlog.Date,'\d{6}','match');
Content.vmlog.Date = datetime([timeStr{:}],'InputFormat','HHmmss','Format','HH:mm:ss')';

[Life is Wonderful]

I guess this is why you have two different functions to read in the data.

Yes, your understanding is right.

vmlog.Date is cell array

ui.Date is datetime array

My question is and I need help - How to convert cell array to datetime array for vmlog.Date ?

[Adam Danz]

I've added a section to the end of my question showing how to do this. The result is

[Life is Wonderful]

Perfect !! Works well.Thank

[Life is Wonderful]

Hi Adam and Guillaume

Can you please help for below link issue

https://in.mathworks.com/matlabcentral/answers/499572-how-to-configure-wlanmacframeconfig

[Adam Danz]

Glad I could help! But for your next question, I'm affraid I know nothing about LAN Medium Access Control.

[Life is Wonderful]

Hi Adam,

Can you please help me with below issue

Link : https://in.mathworks.com/matlabcentral/answers/501212-app-design-ui-figure-how-add-excek-like-filter-selection

Thank you!!

Answer 2

[Sylvain Lacaze]

Hi Matlab,

You're overriding yourself:

structtable.Date = duration(structtable.Date.Hour, structtable.Date.Minute, structtable.Date.Second);

In the first iteration of the loop, structtable.Date is a datetime array, but you then step on it, to make it a duration. In the second iteration of the loop, structtable.Date.Hour doesn't exist (Hour is not a property of a duration object).

Did you mean:

structtable.SomeotherVariableNameLikeDuration = duration(structtable.Date.Hour, structtable.Date.Minute, structtable.Date.Second);

HTH,

Sylvain