So which is the master and which is the detail? On 6/6/22 21:32, Glenn Knickerbocker wrote:
PIPE ... | lookup autoadd w3 w2 ... FPLLUP761E Different key fields not allowed with AUTOADDWhy not? It wasn't hard to write the pipeline to add the records to the reference myself, but in the general case it gets pretty fiddly, grabbing the nonmatches from output 1 and delaying them with COPY before adding them to input 2 so LOOKUP doesn't try to read and write at the same time: (end /) ... | match: lookup ... / ... | match: | nonmatch: fanout | ... / ... | add: fanintwo | match: | ... / nonmatch: | copy | add: Sure would be nice if LOOKUP could just accept the different key fields. ¬R
