Extracting data from two tables with the same ID's

I have two tables:
So they are different size, and ID's from first columns are the same identificators. I would like to extend the table Selected_Processess, so in 3rd column I'd parameter amount_of_occurences from table Processes(:,2) but just for shared ID's from first columns, so for example for the first 2 rows(only this two are visible and shared ID's between the tables in those screenshots) it would look like:
table = [2 2 6;
15 1 4]
After this, the table should have size 228x3.
I was doing similar thing with strings inside cellarray, and function isamember worked perfectly, but for integers it's different.
Ps. I don't mind changing this data from table to any other form such as cell, etc. as long as it would work as I need.
Thanks in advance for your help :)

1 件のコメント

the cyclist
the cyclist 2021 年 5 月 17 日
Are you able to upload the data, so we can test suggested code?

サインインしてコメントする。

 採用された回答

the cyclist
the cyclist 2021 年 5 月 17 日

1 投票

I didn't completely follow what you are trying to do, but I'm pretty sure you should be able to use the join command to do what you want.

1 件のコメント

M
M 2021 年 5 月 18 日
Thank you, this is exactly what I needed :)

サインインしてコメントする。

その他の回答 (0 件)

カテゴリ

ヘルプ センター および File ExchangeTables についてさらに検索

製品

リリース

R2020b

質問済み:

M
M
2021 年 5 月 17 日

コメント済み:

M
M
2021 年 5 月 18 日

Community Treasure Hunt

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

Start Hunting!

Translated by