Working with tables that are within a timetable

Hi there,

I have a 10x1 timetable. Each row in that timetable is another table with the list of positions (rows), and their properties (columns) for those dates.

I need to work with that data, for example, create another timetable with only the positions for which one of the properties is equal to X.

But I'm not able to tacke the tables.

The code I had was: D = TT.Issue{:,Column10==FIX};

Is not working, nor: D = TT.Issue.Column10=='FIX';

Can someone help please?

Answer 1

[J. Alex Lee]

I would first flatten the table, especially if you will be making many queries. Something like

DataCell = cell(height(TT),1);
For i=1:height(TT)
  t = TT{i,"Issue"};
  T.Time = repmat(TT.Time(i), height(TT),1)
  DataCell{i} = t;
end

Data = vertcat(DataCell{:})

Then query as a usual table

RowMask = Data.Column10=='FIX'
NewTable = Data(RowMask,:)

The rowmask line may fail if column10 is not of type categorical

[Lisbon]

Hi There! Many thanks for the help. Is not working though.

"Undefined operator '*' for input arguments of type 'datetime'." Error.

[J. Alex Lee]

Oops should have known...I edited to use repmat, which I think should work.

[Lisbon]

Error on RowMask = Data.Column10=='FIX':

Dot indexing is not supported for variables of this type.

[J. Alex Lee]

Yes, you might consider typing your columm10 as a categorical if it makes sense.

Data.Column10 = categorical(Data.Column10)