MATLAB Answers

how to add lable into rows

1 view (last 30 days)
Tran Trang
Tran Trang on 22 Jul 2019
Commented: TADA on 22 Jul 2019
Hi,
I have a excel fie with goods code and goods name.
I have another excel file (the second file) with goods code only and other data columns. Now I want to label each good code with its good name in the second file. Each good code and name will be repeated in 60 rows, i.e. from row 1 to 60 belongs to good A with lable A, from row 61 to 120 belong to good B with label B and it goes on and on until my table has complete row names. The range to set the good name is every 60 rows and it change to another name that is consistent with its good code.
Thank you very much!

  0 Comments

Sign in to comment.

Accepted Answer

TADA
TADA on 22 Jul 2019
You need to use an inner join
t3 = join(otherTable,goods,'key','keyColumnName')
Or if the key column name is different in both tables,
t3 = join(otherTable,goods,'LeftKeys','otherTableGoodsCode','RightKeys','goodsCode')

  2 Comments

Tran Trang
Tran Trang on 22 Jul 2019
Thank you. Never thought that it is that simple.
TADA
TADA on 22 Jul 2019
Cheers

Sign in to comment.

More Answers (0)

Sign in to answer this question.