concatenating with readtable function

5 views (last 30 days)
Daniel Abraham
Daniel Abraham on 19 Jul 2021
Commented: KSSV on 19 Jul 2021
Hello Everyone. Please I'm trying to readtables from a multiple xml files in a loop. Each xml file holds data for a time period.
Using the code below reads each xml file as a table
table1: readtable('filename.xml')
but I want to read all the xml files in the folder at once as a table so I can get to see all data at once. When I try to read random xml files as tables. It seems most have the same amount variables but some differ. I think for me, it's okay if the code can skip these files.
Thank you so much

Accepted Answer

KSSV
KSSV on 19 Jul 2021
xmlFiles = dir('*.xml') ;
N = length(xmlFiles) ;
T = cell(N,1) ;
for i = 1:N
T{i} = readtable(xmlFiles(i).name) ;
end
celldisp(T)
  2 Comments
KSSV
KSSV on 19 Jul 2021
If the varable names are same and T1, T2 can be joined:
T12 = [T1; T2] ;
Also have a look on cat.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!