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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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

 

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