how to make the size of 2 boards equal

in this pics you see the output i want to do

i've 2 table A and B

>> size(A)

ans =

560 2

>> size(B)

ans =

188 1

i want to use array2table(A,B) to create union and later plot the table in app designer using uitable

but it gives me error

T_=array2table(A,B)

Error using array2table

Wrong number of arguments.

this error because the tables have different dimensions.. How to add blanks to the second to match lengths?

[Walter Roberson]

Possibly innerjoin

[Star Strider]

Another option might be synchronize (Synchronize Timetables)

[aldo]

ok i try it

Answer 1

[Image Analyst]

If they have the same number of columns and you just want to stitch them together, one atop the other, try

AB = [A; B]

[aldo]

have the same number of columns but different number of rows

[Image Analyst]

Then it should work to stack the tables on top of each other, as long as the columns have the same names. Did you try it? Did I understand correctly what you want? If not, please explain better with examples of the two inputs and one output you are trying to achieve.

[aldo]

this is exactly what i want to do The 3 columns are side by side and occupy the whole table screen... the width is the same for all 3 (2 columns) while the length is different

e=[a;b;c]

Error using tabular/vertcat

Timetables and tables may be concatenated only when the timetable is first. Convert

all inputs to the same data type, or change their order.

[Image Analyst]

OK, so column 1 is different. For A column 1 are times but not for B and C.

If you have any more questions, then attach your data (A, B, and C in a .mat file) and code to read it in with the paperclip icon after you read this:

TUTORIAL: How to ask a question (on Answers) and get a fast answer

[aldo]

i give link because using attachment is so longer and it rejected me

https://1drv.ms/f/s!AoJ_s5U2sYnBjt4SZI7E0PrFmXkaXQ?e=ZPiNv4

>> class(a)

ans =

'string'

>> class(b)

ans =

'timetable'

>> class(c)

ans =

'timetable'

[aldo]

i try to according lenght c to b:

s=height(b)-height(c);
s1=repmat({" "},s,2);
A=timetable2table(b);
A.Properties.VariableNames={'Date','Prof'};
B=cell2table(s1);
B.Properties.VariableNames={'Date','Prof'};
T=vertcat(A,B)

but it give me an error and I think this laborious road is not correct

[aldo]

THIS IS MY SOLUTION (it's orrible...i'd like to learn the better version)

a,b,c

whos a

Name Size Bytes Class Attributes

a 560x2 69728 string

>> whos b

Name Size Bytes Class Attributes

b 188x1 3997 timetable

>> whos c

Name Size Bytes Class Attributes

c 16x1 1245 timetable

s=height(a)-height(b);
%end
s1=repmat({" "},s,2);
A=timetable2table(b);
%Acell=table2cell(A)

A.Properties.VariableNames={'Date','Prof'};
B=cell2table(s1);
B.Properties.VariableNames={'Date','Prof'};

A1=convertvars(A,{'Date','Prof'},'string');
T1=vertcat(A1,B)
%T1cell=[Acell,s1];


s=height(a)-height(c);
%end
s1=repmat({" "},s,2);
A=timetable2table(c);
A.Properties.VariableNames={'Date','Prof'};
B=cell2table(s1);
B.Properties.VariableNames={'Date','Prof'};

A1=convertvars(A,{'Date','Prof'},'string');
T2=vertcat(A1,B)

T1_=table2cell(T1);
T2_=table2cell(T2);

TT=[T,T1_,T2_]
T_finally=array2table(TT);

[Walter Roberson]

It is not possible to concatenate a string and a table or time table. You need to convert the string to a timetable.

Profit = double(a(:,2));
Data = datetime(a(:,1));
a_tt = timetable(Profit, 'RowTimes', Data);

output = [a_tt; b; c];

[aldo]

hi walter,

the problem started in a different way..there were 3 matrices to be concatenated having different lengths.. With your solution I create a timetable but I didn't concatenate the 3 arrays horizontally.

In my "T_finally" I am able to do this

(and in app designer it works)

[Image Analyst]

So is it all working now?

To stitch together horizontally you use commas and they all need to have the same number of rows.

To stitch together vertically you use semicolons and they all need to have the same number of columns. In addition, if the variables are tables, then I think the columns in the table must all have different field names.

There are a lot of "joining" table functions that may get around some of the restrictions I just mentioned above.

Sometimes it's better and easier to do stitching as regular double arrays before converting the array into a table. Just depends on exactly what you want to do (what output you want).

[aldo]

ok thanks