MATLAB: Merging two tables gives me an error

merging two tables

Hi, I am trying to merge two tables but i get the following error. why is that? the first table consists of 6 columns and 100000 rows and the second one consists of 6 columns and 2000000 rows. thanks

join(x20062008,x20082010) Error using table/join (line 111) The key variable for B must have unique values.

Best Answer

Try using semicolon. Try this:

t1 = table(['M';'F';'M'],[45;32;34],...
    {'NY';'CA';'MA'},logical([1;0;0]),...
    'VariableNames',{'Gender' 'Age' 'State' 'Vote'})
t2 = table(['M';'F';'M'],[49;54;14],...
    {'AZ';'AK';'OH'},logical([1;0;0]),...
    'VariableNames',{'Gender' 'Age' 'State' 'Vote'})
tJoined = [t1;t2]

Related Solutions

MATLAB: Keep specific column variables and delete others

Var1 = {'Sanchez';'Johnson';'Li';'Diaz';'Brown'};
Var2 = [38;43;38;40;49];
Var3 = logical([1;0;1;0;1]);
T = table(Var1,Var2,Var3)

To keep columns one and three:

T = [T(:,1) T(:,3)]
T =
    5×2 table
        Var1       Var3 
      _________    _____
      'Sanchez'    true 
      'Johnson'    false
      'Li'         true 
      'Diaz'       false
      'Brown'      true

Adapt the code for columns 2 and 4.

MATLAB: How to extract column name of table in matlab

If you refer to uitable:

>> f = figure('Position',[200 200 400 150]);
>> dat = rand(3); 
>> cnames = {'X-Data','Y-Data','Z-Data'};
>> rnames = {'First','Second','Third'};
>> t = uitable('Parent',f,'Data',dat,'ColumnName',cnames,... 
               'RowName',rnames,'Position',[20 20 360 100]); %from matlab help

>> get(t,'columnname')
ans = 
      'X-Data'
      'Y-Data'
      'Z-Data'

If you refer to table:

>> T = table(['M';'F';'M'],[45;32;34],...
             {'NY';'CA';'MA'},logical([1;0;0]),...
             'VariableNames',{'Gender' 'Age' 'State' 'Vote'}); %from matlab help
>> T.Properties.VariableNames
ans = 
    'Gender'    'Age'    'State'    'Vote'

Best Answer

Related Solutions

MATLAB: Keep specific column variables and delete others

MATLAB: How to extract column name of table in matlab

Related Question