How to find which columns are different between two tables

Hello:

I have 2 datasets (Table A and Table B). Table A has 1200 columns while that of B has 1205 columns. They all have the same number of rows. A and B are supposed to be the same but for some reason when I save A, 5 additional columns are added hence I get B (1205 columns instead of 1200).

I wanna find out what those 5 additional columns are. Is there a code that can let me compare A and B and tell me what those additional 5 columns in Table B are?

Thank you and I look forward to hearing from you soon.

[Walter Roberson]

Can you attach a .mat containing the two?

How are you doing the saving?

Which MATLAB release are you using?

[Curious Mind]

Unfortunately I don’t have the files with me now. I’m saving Table A as a .dat file. I’m using 2017a version. It works fine just happened today. Every time I save data A 5 additional columns of data are added and I wanna know what those 5 columns are.

[Walter Roberson]

.dat is not a standard file type. How are you doing the saving?

Answer 1

[Dankur Mcgoo]

A = rand(3,3); 
B = [A, rand(3,1)]; % Generating random tables
idx = ~ismember(B,A);
LookSee = B(idx);

LookSee should have the columns you want...

[Curious Mind]

So since I have TableA and TableB would the code be like A = TableA; B = [A, TableB]; idx = ~ismember(B,A); LookSee = B(idx); ?

[Dankur Mcgoo]

Yup!