Re: [U2] Left Outer Join Question

I Use MERGE.LIST a lot.

Say for instance you want to know how many emails from an excel file are
  In a customer file.

If you sort the excel file by email, then click on the excel column header, right click and copy
Then go to UV,  EDIT-LIST EM1,  I<ENTER>  Then paste the clipboard and File that
SELECT CUSTOMERFILE SAVING UNIQUE EMAIL
SAVE-LIST EM2

GET-LIST EM1 TO 1
GET-LIST EM2 TO 2
MERGE.LIST 1 DIFF 2
SAVE-LIST EMAILS-NOT-IN-CUSTOMER-FILE

GET-LIST EM1 TO 1
GET-LIST EM2 TO 2
MERGE.LIST 2 DIFF 1
SAVE-LIST EMAILS-NOT-IN-EXCEL-FILE

And so on....


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Charles Stevenson
Sent: Tuesday, March 04, 2014 4:24 PM
To: U2 Users List
Subject: Re: [U2] Left Outer Join Question

Randy,

It sounds like NSELECT is what you need.
But MERGE.LIST is a handy thing to get working.

_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users