Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

confirm unique tuple?

becki
8 - 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

 

3 REPLIES 3
tcroberts
12 - Quasar

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
8 - 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

 

kgalbert
9 - Comet

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