Another way to do this would be to create an array of all the rows in array1
that are not in array2, and an array of all the rows in 2 that are not in 1,
then append them together.
<@assign local$array1 <@array value="1;2;4;5;6;">>
<@assign local$array2 <@array value="2;3;4;5;6;7;">>
<@assign local$in1not2
<@filter array=local$array1 expr="!(@@local$array2 contains #1)">>
<@assign local$in2not1
<@filter array=local$array2 expr="!(@@local$array1 contains #1)">>
If both arrays are not empty then
the result is local$in1not2 + local$in2not1
Else if local$in1not2 is not empty
the result is local$in1not2
Else
the result is local$in2not1
<@if expr="<@numrows array=local$in1not2>>0 && <@numrows
array=local$in2not1>>0">
<@assign local$result @@local$in1not2>
<@addrows array=local$result value="@@local$in2not1">
<@elseif expr="<@numrows array=lcoal$in1not2>>0">
<@assign local$result @@local$in1not2>
<@else>
<@assign local$result @@local$in2not1>
</@if>
@@local$result then contains the values 1;3;7;
Note that though this method uses only 2 filters and an addrows to implement
an exclusive or, the filter statements can be quite slow if the arrays are
large.
Also, I ran the code above through my tango debugger an it works, however
some modifications will be required for multi-column arrays or when doing
the comparison on a variable column number.
Dave Shelley
-----Original Message-----
From: Wolf, Gene [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 5:23 PM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Array processing
This would give me all members of both arrays. Yes, I could then use that to
look at each individual array and if the number in the Union'd array did not
appear I could build my own list. I was just hoping that there was some
function I may have overlooked that would do this for me. *laughs*
Apparently not from the responses. Sounds like it's time for me to build a
tcf to do this.
-----Original Message-----
From: Matt Muro [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 16, 2006 5:14 PM
To: witango-talk@witango.com
Cc: witango-talk@witango.com
Subject: Re: Witango-Talk: Array processing
Just a thought as I run out the door here (I haven't tried this) ...
What about using <@UNION> to combine the arrays and then performing
<@DISTINCT> on the combined array to have only the DISTINCT elements
returned.
witango-talk@witango.com on Thursday, February 16, 2006 at 5:03 PM -0500
wrote:
> Not at all. Assume I have array 1 with the following rows:
>
>1
>2
>3
>4
>5
>
>And I have Array 2 with the following rows:
>
>2
>3
>5
>6
>7
>
>I'd like to have some kind of function that would tell me all of the
>elements of these two arrays that do not appear in BOTH arrays, those
>being 1,4,6,7. Does that help?
>
>-----Original Message-----
>From: Scott Cadillac [mailto:[EMAIL PROTECTED]
>Sent: Thursday, February 16, 2006 4:59 PM
>To: witango-talk@witango.com
>Subject: RE: Witango-Talk: Array processing
>
>
>Hi Gene,
>
>> I need something that compares
>> two arrays and returns to me those rows that do not exist in
>> BOTH arrays.
>
>I don't get it. Is this a trick question?
>
>
>Scott Cadillac,
>Email: [EMAIL PROTECTED]
>http://scott.cadillac.bz
>
>
>
>
>> -----Original Message-----
>> From: Wolf, Gene [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, February 16, 2006 2:42 PM
>> To: witango-talk@witango.com
>> Subject: Witango-Talk: Array processing
>>
>> I've seen a number of the array processing commands like
>> @intersect, @Union, etc. but I need something that compares
>> two arrays and returns to me those rows that do not exist in
>> BOTH arrays. Is there anything like the equivalent of
>> [EMAIL PROTECTED] *laughs*
>> ______________________________________________________________
>> __________
>> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
>>
>
>
>________________________________________________________________________
>TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
>________________________________________________________________________
>TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
>
________________________________________________________
Matt Muro [EMAIL PROTECTED]
Harvard University phone: 617.998.8522
Division of Continuing Education fax: 617.495.9176
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
