community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

confirm unique tuple?

Asteroid

( 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

 

Alteryx Partner

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!

Asteroid

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

 

Highlighted
Asteroid

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.

Labels