I am concatenating tables in a large loop. all these tables are imported from excel . sometimes Matlab imports the same column as in cells and sometimes as double which is leading to the following errors. For example:
Cannot concatenate the table variable 'TargetBook' because it is a cell in one table and a non-cell in another. the examples are numerous for different columns.
How can I force the concatenation by transforming one column type to fit the precedent table column type in order to concatenate successfully?
in other words
for k = 1:numel(List)
File = fullfile(Base,List(k).name);
Result = readtable(File);