matching

[ntudev]

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

ZIP	ZIP1			PIZ	PIZ1	does it match?
259530	311412			259530	311412	match
259530	311412			259530		match
259530	311412			259530		match
259530	311412			259530		match
259530	311412			259530		match
259530	311412			259530		match
259530	311412			259530		match
259530	311412			259530		match

[DanM]

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]

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.

[CarliE]

@ntudev 

You would solve that a little bit differently in that case

Attached is the workflow

[michelle_mathews]

@ntudev , attached is the solution I'd use

[ntudev]

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			PIZ	Does it Match?
311412			311412	match
311412			311412	match
311412			311412	match
311412			311412	match
311412			311412	match
311412			311412	match
311412				match
311412				match
325698			459878	Changed

[binuacs]

@ntudev One way of doing this

[CarliE]

@ntudev 

is this what you're looking for?