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.

matching

ntudev
8 - Asteroid

Hello, can someone help with a formula that will create a new column that says 'match' as long as the ZIP matches the PIZ and as long as PIZ1 has the same value as ZIP1  just in 1 box. and even if its blank it should also be match

 

ZIPZIP1  PIZPIZ1does it match?
259530311412  259530311412match
259530311412  259530 match
259530311412  259530 match
259530311412  259530 match
259530311412  259530 match
259530311412  259530 match
259530311412  259530 match
259530311412  259530 match
7 REPLIES 7
DanM
Alteryx Community Team
Alteryx Community Team

I would review this lesson https://community.alteryx.com/t5/Interactive-Lessons/Writing-Conditional-Statements/ta-p/98910

I would also post to show what you've tried so far so the Community understands your level of writing expressions.

ntudev
8 - Asteroid

I think i'm almost there but the last row (10) is saying its a match it actually should be a not match. Any ideas? The reason row 7&8 is a match is because Zip column is a match as long as there is a matching Piz anywhere in the column Piz. Hopefully this makes sense.

 

ntudev_1-1655232579307.png

 

 

CarliE
Alteryx Alumni (Retired)

@ntudev 

 

You would solve that a little bit differently in that case

 

Attached is the workflow

CarliE_0-1655233182064.png

 

Carli

@ntudev , attached is the solution I'd use

 

Capture.PNG

ntudev
8 - Asteroid

i did not expect this to be more then a formula, but this works too. I was wondering how i would make it to say changed if Zip and Piz are really different and New if it doesnt match to anything in PIZ.

 

Zip  PIZDoes it Match?
311412  311412match
311412  311412match
311412  311412match
311412  311412match
311412  311412match
311412  311412match
311412   match
311412   match
325698  459878Changed
binuacs
20 - Arcturus

@ntudev One way of doing this

 

binuacs_0-1655240997978.png

 

CarliE
Alteryx Alumni (Retired)

@ntudev 

is this what you're looking for?

CarliE_0-1655241401442.png

 

 

Carli
Labels