I want to concatenate two coloumns of table.

Two coloumns of my table are as follows:

Freqa Freqb

950 1500

2000 2070

3000 3070

4000 4070

And I want to provide this as an input to my function of different module which need input freq as

freq

950

1500

2000

2070

3000

3070

4000

4070

And using this command c= [freqa(:,1); freqb(:,2)]. MATLAB shows me this error: All tables being vertically concatenated must have the same variable names. I cant chnage the variable of my excel sheet so how to perform this concatenation operation please let me know.

Answer 1

[Jon]

I am assuming you have a single MATLAB table, let's call it T, with two columns, one called freqa and another freqb.

In this case, you can do what you want using:

freq = [T.freqa;T.freqb]

[Aakriti Srivastava]

Thanks it worked. I was wrong with my notation to columns.

Answer 2

[Voss]

Let's say you have a table t with variables freqa and freqb.

freqa = [950; 2000; 3000; 4000];
freqb = [1500; 2070; 3070; 4070];

t = table(freqa,freqb);

Then freq given below is a column vector of all elements of freqa and freqb in the required order:

% one way:
freq = reshape([t.freqa t.freqb].',[],1)

freq = 8×1

950 1500 2000 2070 3000 3070 4000 4070

% another way:
freq = reshape(t{:,{'freqa' 'freqb'}}.',[],1)

freq = 8×1

950 1500 2000 2070 3000 3070 4000 4070

Or, let's say you have two tables freqa and freqb

freqa = table([950; 2000; 3000; 4000],[1500; 2070; 3070; 4070]);
freqb = table([950; 2000; 3000; 4000],[1500; 2070; 3070; 4070]);

(so that I can reproduce the error you got using the code you showed)

try
    c= [freqa(:,1); freqb(:,2)]
catch ME
    disp(ME.message);
end

All tables being vertically concatenated must have the same variable names.

If that's the situation, then you can construct freq (or c if you want to call it that) like this:

freq = reshape([freqa{:,1} freqb{:,2}].',[],1)

freq = 8×1

950 1500 2000 2070 3000 3070 4000 4070

In either case, you can make the result freq into a table by

freq = table(freq)

freq = 8×1 table
    freq
    ____

     950
    1500
    2000
    2070
    3000
    3070
    4000
    4070

if that's what the input of the function needs to be.

[Aakriti Srivastava]

Hy Voss, I tried this freq = reshape([freqa{:,1} freqb{:,2}].',[],1). But it still shows me the same error. So I am sharing with you the table and hope this gives more clarity to my ques of concatenation.

Filter mat file Freqa Freqb Comments

B1 B1X_approximation_freq.mat 950 1500 Freq in MHz

B2 B2X_approximation_freq.mat 2000 2070

B3 B3X_approximation_freq.mat 3000 3070

B4 B4X_approximation_freq.mat 4000 4070

[Voss]

Can you upload (using the paperclip button) a mat file containing the table(s) or the spreadsheet file(s) containing the table(s)?

[Aakriti Srivastava]

the spreadsheet file attached hope this make more clarity.

[Aakriti Srivastava]

Thanks Voss, after your discription to solution I understand my mistake.