how to copy values from one table to other table

5 views (last 30 days)
Hi,
I have a table with a columns of say 10 values from 1 to 10 and I have an array of 5 values with values as 2, 4, 6, 7,8. How do i create a new column in the table which will copy the data from the array match with the table values and fill Nan on those values which are not same?
Like this
New_row
Nan
2
Nan
4
Nan
6
7
8
Nan
Nan

Answers (3)

madhan ravi
madhan ravi on 10 Apr 2019
Edited: madhan ravi on 10 Apr 2019
T1=table((1:10).');
T2=table([2, 4, 6, 7, 8].');
outerjoin(T1,T2)

Shambhavi Adhikari
Shambhavi Adhikari on 10 Apr 2019
I ran into this error
Error using tabular/outerjoin (line 148)
Cannot find a common table variable to use as a key variable.
Error in new_code (line 12)
T=outerjoin(T,T2);
  1 Comment
madhan ravi
madhan ravi on 10 Apr 2019
Edited: madhan ravi on 10 Apr 2019
You have problems with copying the code correctly. Go back, copy my answer and paste it in the command window.

Sign in to comment.


Shambhavi Adhikari
Shambhavi Adhikari on 10 Apr 2019
Now this error
Error using tabular/outerjoin (line 148)
Left and right key variables 'Var1' and 'Var1' do not have the same number of columns.
Error in new_code (line 13)
T=outerjoin(T,T2);
  2 Comments
Shambhavi Adhikari
Shambhavi Adhikari on 10 Apr 2019
I did copy it in command window.. Same error..
Error using tabular/outerjoin (line 148)
Left and right key variables 'Var1' and 'Var1' do not have the same number of columns.

Sign in to comment.

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!