Tall table from multiple tables in different .MAT files

I have a ton of separate .mat files, each containing a single table. They have the same variables, and same format for each variable. Combined, they do not fit into memory.

Is there a way to create a datastore or a tall table from these? Tried using datastore but, surprisingly, there doesn't seem to be an option for this.

I realize one option would be to loop through these, "convert" them to CSV, and make a datastore from this. This is my backup plan.

Thanks

Answer 1

[Krishna Bindumadhavan]

The procedure that you have mentioned in the question (converting the files to .csv and then making a datastore) should work. Alternatively, you can also use a FileDatastore (used for custom file formats) as outlined in the documentation here :

https://www.mathworks.com/help/matlab/ref/filedatastore-object.html

The example provided in the documentation shows how you can use FileDatastore with .mat files.

Hope this helps!

Answer 2

[Anandan Rangasamy]

I would suggest you to set UniformRead to true when creating FileDatastore to get a tall table. Here is an example.