Combine/join table based on common names

Question

Mohammed Kamruzzaman 2015-4-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/211571-combine-join-table-based-on-common-names

评论： Star Strider 2015-4-21

 I have two tables with sting and their length is different. I want to make a table with common string;
 CSN_PROV1_20130209          CSN_PROV1_20130209
 CSN_WADC1_20131004          CSN_WADC1_20131004
CSN_PROV1_20130320         CSN_PROV1_20130320
CSN_WADC1_20131203         CSN_WADC1_20130430
CSN_BEHI1_20130127         CSN_PROV1_20131111
                                CSN_BEHI1_20130127

I want my new table as:

 CSN_PROV1_20130209                
CSN_WADC1_20131004
CSN_PROV1_20130320
CSN_BEHI1_20130127

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2015-4-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/211571-combine-join-table-based-on-common-names#answer_176029

在 MATLAB Online 中打开

I had to reconstruct your arrays so they would work. I believe the intersect output is what you want, but I listed the unique output as well:

T1 = ['CSN_PROV1_20130209'      
    'CSN_WADC1_20131004'         
    'CSN_PROV1_20130320'         
    'CSN_WADC1_20131203'         
    'CSN_BEHI1_20130127'];
T2 = ['CSN_PROV1_20130209'
    'CSN_WADC1_20131004'
    'CSN_PROV1_20130320'
    'CSN_WADC1_20130430'
    'CSN_PROV1_20131111'
    'CSN_BEHI1_20130127'];
Tu = unique([T1; T2], 'rows')       % Unique Elements
Ti = intersect(T1, T2, 'rows')      % Intersecting Elements

producing:

Tu =
CSN_BEHI1_20130127
CSN_PROV1_20130209
CSN_PROV1_20130320
CSN_PROV1_20131111
CSN_WADC1_20130430
CSN_WADC1_20131004
CSN_WADC1_20131203
Ti =
CSN_BEHI1_20130127
CSN_PROV1_20130209
CSN_PROV1_20130320
CSN_WADC1_20131004