Re: [U2] Left Outer Join Question

I love learning little tidbits like this, that's awesome!

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Bill Haskett
Sent: Monday, March 03, 2014 10:39 AM
To: U2 Users List
Subject: Re: [U2] Left Outer Join Question

Then, there's always:

:SELECT FILE1
xxx items selected.
 >NSELECT FILE 2
yyy items selected.
 >

You can also do the same as noted below with an "EVAL" command. e.g.

:select FILE1 WITH EVAL "TRANS('FILE2', @ID, 0, 0)" = ""
xxx items selected.
 >

Bill

------------------------------------------------------------------------
----- Original Message -----
*From:* [email protected]
*To:* U2 Users List <[email protected]>
*Date:* 3/3/2014 9:56 AM
*Subject:* Re: [U2] Left Outer Join Question
> The usual "pick" way to do this is to create an attribute:
>
> AE DICT FILE1 BLACKLIST
> 001: I
> 002: TRANS("FILE2", @ID, 0, 0)  ; or really old-school 
> OCONV(@ID,"TFILE2;X;0;0")
> 003:
> 004:
> 005: 20L
> 006: S
>
> :GET.LIST L1
> 1000 Items Selected
> :SELECT FILE1 WITH BLACKLIST = ""
> 600 Items Selected
>
>
>
>
> -----Original Message-----
> From: [email protected] 
> [mailto:[email protected]] On Behalf Of 
> randyleesmith
> Sent: Monday, March 03, 2014 9:44 AM
> To: [email protected]
> Subject: [U2] Left Outer Join Question
>
> I have 2 files.
>
> File 2 is a black list of records (keys) I want to exclude in and active select list of File 1.
>
> I've been looking into this for a little while and am not sure what I'm doing wrong.
>
> Docs are not very helpful with any examples on the how to do with this.
>
>
> I know of ways to deal with this in code, but was hoping for an SQL way to deal with it.
>
>
>
>
>
>
>
> -----
> I used to be an Optimist until I knocked over the glass.
> --
> View this message in context: 
> http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Quest
> ion-tp42740.html Sent from the U2 - Users mailing list archive at 
> Nabble.com.
> _______________________________________________
> U2-Users mailing list
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> -----------------------------------------
> IMPORTANT NOTICE:   This message is intended only for the addressee
> and may contain confidential, privileged information.  If you are not 
> the intended recipient, you may not use, copy or disclose any 
> information contained in the message.  If you have received this 
> message in error, please notify the sender by reply e-mail and delete 
> the message.
> _______________________________________________
> U2-Users mailing list
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users

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