How can I modify table by horizontal row wise from three different tables?

Question

Mohammad Hossain 2018-4-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/392282-how-can-i-modify-table-by-horizontal-row-wise-from-three-different-tables

编辑： Mohammad Hossain 2018-4-4

There are two tables with three columns. First two columns will be considered as a pair and third column is output. Table 2 is a branch of the main table and Table 1 is coming from different source with different pairs and outputs. Now I'm looking to modify Table 2 where I want to add only uncommon pairs from Table 1 but the output values will be taken from main table depending on the pairs, not from the Table 1. Common pairs and pairs with no output from main table will not be added in the modified table. The size of the all table might vary.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Peter Perkins 2018-4-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/392282-how-can-i-modify-table-by-horizontal-row-wise-from-three-different-tables#answer_313398

Your question is not really clear to me, but likely you want some combination of setdiff and join. A simple example would help.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Mohammad Hossain 2018-4-4

There are two tables (Table 1 and Table 2), that I found from another program. Now I want to compare between them on the basis of col_1 and col_2 (considered as a pair in row wise) and want to modify Table 2. In the modified Table 2, all the pairs will come from Table 2 with their values (values in 3rd column) and also pairs will come from Table 1, those are not common in Table 2. However, these uncommon pairs will leave their original values in 3rd column but they need to search a new value from Main table. If available, then the pairs with new value will be put in modified Table 2. The size of Table 1 and Table 2 might vary but Main Table size is fixed.

请先登录，再进行评论。