confirm unique tuple?

[becki]

( i should know this and i'm blanking)

out of data, i create a bunch of unique tuples, from 3 different fields.  what I am confused about is how do i confirm the data in field1 is not repeated with any other field2 or field 3?  

thanks

becki kain

[tcroberts]

You could add a formula tool with something like:

IF [Field1] = [Field2] OR [Field1] = [Field3]

THEN 1

ELSE 0

ENDIF

In this case, all of the rows with 1's in that field would have a value duplicated.

Let me know if this helps,

Cheers!

[becki]

i'm not describing this correctly.  I have 3 fields, for example:

field 1 is body description =sedan

field 2 is body code = KO

field 3 is nameplate = escape

I need to make certain that body code of KO is only "sedan" , in the came of nameplate "escape" and not also description of "hatchback"

how do I do that?  thanks

[kgalbert · Accepted solution]

I think you could join the dataset back to itself multiple time then use filters to limit the results. ([Field 2] = [Right_Field 2] and [Field 3] = [Right_Field 3]) then look at the false end of the filter.

If you post some example data I can show the filter better.