Hello, Is there an idiom to enrich a file with another file ... 1. ... if the reference file is not too large ? 2. ... if the reference file is very large ?
- For a "not too large" reference, I had done it with a "LOOKUP ... DETAIL ALLMASTER PAIRWISE" + "JOIN" + "SPEC", but is there a better way ? - For a "very large reference", I'll try and use a "COLLATE", but it has no "PAIRWISE" option, so I'd try and prefix each file with a different character before collating, and work the result. But that seems complex. Any simple idea ?
Example of what I want : FIRST INPUT FILE : AA1aa BB2bb CC2cc DD3dd SECOND INPUT FILE (the reference : keys -> values) : 1One 2Two 3Three OUTPUT FILE : AAOne aa BBTwo bb CCTwo cc DDThree dd Thanks Michaël
