how to copy values from one table to other table

5 次查看（过去 30 天）
Shambhavi Adhikari
Shambhavi Adhikari 2019-4-10
评论： madhan ravi 2019-4-10
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

请先登录，再回答此问题。

回答（3 个）

madhan ravi
madhan ravi 2019-4-10
编辑：madhan ravi 2019-4-10
T1=table((1:10).');
T2=table([2, 4, 6, 7, 8].');
outerjoin(T1,T2)
Shambhavi Adhikari
Shambhavi Adhikari 2019-4-10
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 个评论
madhan ravi
madhan ravi 2019-4-10
编辑：madhan ravi 2019-4-10
You have problems with copying the code correctly. Go back, copy my answer and paste it in the command window.

请先登录，再进行评论。

Shambhavi Adhikari
Shambhavi Adhikari 2019-4-10
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 个评论
Shambhavi Adhikari
Shambhavi Adhikari 2019-4-10
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by