Copying colums from table to a new table

I am struggling with a quite simple issue:

I have multiple different sized tables, and i would like to copy last columns of every (time)table to a new table that i have not defined. That doesn't work because the length are different in every column. The excessive values in some columns could be set as "Nan"s or just removed. IS there a easy way to do this? The only method that comes to my mind is to create an excel .csv file with zeros, but my tables are very large.

Answer 1

[Adam Danz]

Follow the demo; see inline comments for details.

% Create 3 timetables of different heights
dt = datetime(2000,1,1,0,0,0) + minutes(0:30:5000)'; 
TT1 = timetable(dt(1:100),rand(100,1)); 
TT2 = timetable(dt(1:85),rand(85,1)); 
TT3 = timetable(dt, rand(size(dt))); 

% List all timetables in a cell array named "allTT"
allTT = {TT1, TT2, TT3}; 

% Get heights of all timetables 
heights = cellfun(@height, allTT); 

% Loop through each timetable and move the last column into 
% the table T; use NaNs as fillers.  
T = array2table(nan(max(heights), numel(allTT)));  % You may want to name your variables here.
for i = 1:numel(allTT)
    T{1:heights(i),i} = allTT{i}{:,end};
end

[Mat P]

Thank you! I think I manage to do just what I want with this

Answer 2

[SC]

Hey, This link might help you:

<https://www.mathworks.com/help/matlab/ref/fillmissing.html>

go to 'Table with Multiple Data Types' in the above link

[Mat P]

Thank you for the answer. I don't think that i can use that. My goal is to copy these columns to new timetable, but i can't do that because the lengths are different. And that doesn't allow me to add extra zeros to the end of smaller tables, to make them all equal sized