Re: Matching where the source file has one record/ subject and the to-be-matched file has multiple records/subect
Ravi Varadhan via R-help <[email protected]> Thu, 23 Jul 2026 18:48:45 +0000
| Newsgroups | gmane.comp.lang.r.general |
|---|---|
| Message-ID | <DS4PR01MB943490F47FFC58C8C83E5856F2C02@DS4PR01MB9434.prod.exchangelabs.com> |
SGVyZSBpcyBhIHRveSBleGFtcGxlIEkgY3JlYXRlZCBtYW55IHllYXJzIGFnbyBvbiBob3cgdG8g dXNlIHRoZSBIdW5nYXJpYW4gYWxnb3JpdGhtIGluIHRoZSAiY2x1ZSIgcGFja2FnZS4gSW4gdGhp cyBleGFtcGxlLCB0aGUgbWF0Y2ggd2lsbCBiZSBleGFjdCBzaW5jZSB0aGUgdHdvIHZlY3RvcnMg YXJlIHNpbXBseSBwZXJtdXRlZCwgYnV0IHRoZXkgbmVlZCBub3QgbWF0Y2ggZXhhY3RseS4gIFRo aXMgYW5zd2VycyBCZXJ0J3MgY29uY2Vybi4gIEFuIGV4YWN0IGRhdGUgbWF0Y2ggaXMgbm90IHJl cXVpcmVkLiBUaGUgYWxnb3JpdGhtIHdpbGwgcGVyZm9ybSBhIG5lYXJlc3QtbmVpZ2hib3IgbWF0 Y2ggYmFzZWQgb24gdGhlIGFic29sdXRlIGRpZmZlcmVuY2UgaW4gZGF5cy4NCg0KIyBSYXZpIFZh cmFkaGFuDQojIEFuIGV4YW1wbGUgZGVtb25zdHJhdGluZyB0aGUgdXNlIG9mIEh1bmdhcmlhbiBh bGdvcml0aG0gZm9yIHNvbHZpbmcgb3B0aW1hbCBtYXRjaGluZw0KIw0KIHJlcXVpcmUoY2x1ZSkN Cg0KIG4gPC0gMTANCiB4IDwtIHJ0KG4sIGRmPTMpICsgMWkgKiBydChuLCBkZj0zKSAgIyB0aGlz IGlzIHNldCBBDQojIHkgPC0geFtzYW1wbGUobildICAjIHRoaXMgaXMgdGhlIHZlY3RvciB0byBi ZSBwZXJtdXRlZA0KIHkgPC0gcnQobiwgZGY9MykgKyAxaSAqIHJ0KG4sIGRmPTMpICAjIHRoaXMg aXMgc2V0IEINCg0KIENtYXQgPC0gb3V0ZXIoeCwgeSwgRlVOPWZ1bmN0aW9uKHgseSkgTW9kKHgg LSB5KSkgICMgQ29zdCBvciBEaXN0YW5jZSBtYXRyaXggYmV0d2VlbiBhbiBlbGVtZW50IG9mIEEg YW5kIEINCg0KIGFucyA8LSBzb2x2ZV9MU0FQKENtYXQsIG1heGltdW09RkFMU0UpICAjIFdlIGFy ZSBtaW5pbWl6aW5nIHRoZSBsaW5lYXIgc3VtDQoNCiBkaXN0IDwtIGZ1bmN0aW9uKHgsIHkpIHNx cnQoc3VtKE1vZCh4IC0geSleMikpDQogZGlzdCh4LCB5W2MoYW5zKV0pDQoNCl9fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fDQpGcm9tOiBCZXJ0IEd1bnRlciA8Ymd1bnRlci40NTY3QGdt YWlsLmNvbT4NClNlbnQ6IFRodXJzZGF5LCBKdWx5IDIzLCAyMDI2IDE0OjEwDQpUbzogUmF2aSBW YXJhZGhhbiA8cmF2aS52YXJhZGhhbkBqaHUuZWR1PjsgUi1oZWxwIDxSLWhlbHBAci1wcm9qZWN0 Lm9yZz47IFNvcmtpbiwgSm9obiA8anNvcmtpbkBzb20udW1hcnlsYW5kLmVkdT4NClN1YmplY3Q6 IFJlOiBbUl0gTWF0Y2hpbmcgd2hlcmUgdGhlIHNvdXJjZSBmaWxlIGhhcyBvbmUgcmVjb3JkLyBz dWJqZWN0IGFuZCB0aGUgdG8tYmUtbWF0Y2hlZCBmaWxlIGhhcyBtdWx0aXBsZSByZWNvcmRzL3N1 YmVjdA0KDQpZb3UgZG9uJ3Qgb2Z0ZW4gZ2V0IGVtYWlsIGZyb20gYmd1bnRlci40NTY3QGdtYWls LmNvbS4gTGVhcm4gd2h5IHRoaXMgaXMgaW1wb3J0YW50PGh0dHBzOi8vYWthLm1zL0xlYXJuQWJv dXRTZW5kZXJJZGVudGlmaWNhdGlvbj4NCg0KICAgICAgRXh0ZXJuYWwgRW1haWwgLSBVc2UgQ2F1 dGlvbg0KDQoNCg0KLi4uIGFuZCByZWxhdGVkIHRvIFJhdmkncyBwb3N0LCB3aWxsIHRoZXJlIGFs d2F5cyBiZSBhdCBsZWFzdCBvbmUgZGF0ZSBpbiBmaWxlIDIgdGhhdCBtYXRjaGVzIGV2ZXJ5IGRh dGUgaW4gZmlsZSAxPyAgQW5kIGlmIHRoZXJlIGlzbid0LCB3aGF0IGFjdGlvbiBzaG91bGQgYmUg dGFrZW4/DQoNCi0tIEJlcnQNCg0KT24gVGh1LCBKdWwgMjMsIDIwMjYgYXQgOTozNuKAr0FNIFJh dmkgVmFyYWRoYW4gdmlhIFItaGVscCA8ci1oZWxwQHItcHJvamVjdC5vcmc8bWFpbHRvOnItaGVs cEByLXByb2plY3Qub3JnPj4gd3JvdGU6DQpUaGlzIGlzIGEgY2xhc3NpYyBtYXRjaGluZyBwcm9i bGVtLCBJIGJlbGlldmUuICBCYXNlZCBvbiB5b3VyIGRlc2NyaXB0aW9uLCB5b3UgYXJlIGxvb2tp bmcgZm9yIGEgMS10by0xIG5lYXJlc3QtbmVpZ2hib3IgbWF0Y2ggYmFzZWQgb24gdGhlIGFic29s dXRlIGRpZmZlcmVuY2UgaW4gZGF0ZXMsIHdpdGggdGhlIGNvbnN0cmFpbnQgdGhhdCBvbmNlIGEg c3ViamVjdCBpbiBGaWxlIDIgaXMgdXNlZCwgYWxsIG9mIHRoZWlyIHJlY29yZHMgYXJlIGRpc2Nh cmRlZC4NCg0KQ29ycmVjdD8NCg0KVGhlcmUgYXJlIHR3byBjbGFzc2ljYWwgYXBwcm9hY2hlczog Z3JlZWR5IG1hdGNoaW5nIGFuZCBnbG9iYWwgb3B0aW1hbCBtYXRjaGluZy4gIFdoaWxlIHRoZSBn cmVlZHkgYXBwcm9hY2ggaXMgc2ltcGxlIHRvIGltcGxlbWVudCBhbmQgb2Z0ZW4gd29ya3MsIGl0 IGNhbiBzb21ldGltZXMgZ2V0IGludG8gdHJvdWJsZSAoaS5lLiwgcnVuIG91dCBvZiBnb29kIG1h dGNoZXMpLiBUaGUgb3B0aW1hbCBhcHByb2FjaCB3b3VsZCB1c2UgdGhlIEh1bmdhcmlhbiBhbGdv cml0aG0gKGUuZy4sIExTQVAgZnVuY3Rpb24gaW4gdGhlIGNsdWUgcGFja2FnZSkgdG8gZmluZCB0 aGUgY29tYmluYXRpb24gb2YgbWF0Y2hlcyB0aGF0IHJlc3VsdHMgaW4gdGhlIGxvd2VzdCB0b3Rh bCBkYXRlIGRpZmZlcmVuY2UgYWNyb3NzIHRoZSBlbnRpcmUgZGF0YXNldC4NCg0KUmF2aQ0KDQog ICAgICAgIFtbYWx0ZXJuYXRpdmUgSFRNTCB2ZXJzaW9uIGRlbGV0ZWRdXQ0KDQpfX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fDQpSLWhlbHBAci1wcm9qZWN0Lm9y ZzxtYWlsdG86Ui1oZWxwQHItcHJvamVjdC5vcmc+IG1haWxpbmcgbGlzdCAtLSBUbyBVTlNVQlND UklCRSBhbmQgbW9yZSwgc2VlDQpodHRwczovL3N0YXQuZXRoei5jaC9tYWlsbWFuL2xpc3RpbmZv L3ItaGVscA0KUExFQVNFIGRvIHJlYWQgdGhlIHBvc3RpbmcgZ3VpZGUgaHR0cHM6Ly93d3cuUi1w cm9qZWN0Lm9yZy9wb3N0aW5nLWd1aWRlLmh0bWw8aHR0cHM6Ly93d3cuci1wcm9qZWN0Lm9yZy9w b3N0aW5nLWd1aWRlLmh0bWw+DQphbmQgcHJvdmlkZSBjb21tZW50ZWQsIG1pbmltYWwsIHNlbGYt Y29udGFpbmVkLCByZXByb2R1Y2libGUgY29kZS4NCgoJW1thbHRlcm5hdGl2ZSBIVE1MIHZlcnNp b24gZGVsZXRlZF1dCgpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fClItaGVscEByLXByb2plY3Qub3JnIG1haWxpbmcgbGlzdCAtLSBUbyBVTlNVQlNDUklCRSBh bmQgbW9yZSwgc2VlCmh0dHBzOi8vc3RhdC5ldGh6LmNoL21haWxtYW4vbGlzdGluZm8vci1oZWxw ClBMRUFTRSBkbyByZWFkIHRoZSBwb3N0aW5nIGd1aWRlIGh0dHBzOi8vd3d3LlItcHJvamVjdC5v cmcvcG9zdGluZy1ndWlkZS5odG1sCmFuZCBwcm92aWRlIGNvbW1lbnRlZCwgbWluaW1hbCwgc2Vs Zi1jb250YWluZWQsIHJlcHJvZHVjaWJsZSBjb2RlLgo=