data analysis

[ntudev]

I'm trying to basically find a way to add a third column that will show me if checks have same codes and if both lastmonthcheck and check have 80 then if there is another check amounts that have the same code but different check amount it will get tagged as 1. example below. If the code is the same but one of the rows has both 80 then even if the 2nd row (with the same code) is 57 then it should get 1. I hope this makes sense

Code	Check	LastMonthCheck	Max Check
348739	80	57	1
348739	80	57	1
348739	80	57	1
348739	80	80	1
348740	80	80	0
348741	80	57	0
348742	80	57	1
348742	80	80	1
348743	80	57	0
348743	80	57	0

[geraldo]

@ntudev 

I'm resubmitting the workflow to see what went wrong

a doubt that was from the other post.
The base already comes in order of releases because in the workflow I gave a sort to organize the base.
if it already comes in the order, just remove the sort from the workflow and adjust the comparisons

[ntudev]

not sure what you mean remove the sort, can you do it in the alteryx package? i ran the one you just sent me but it still shows the old version.

[geraldo]

@ntudev 

This version serves a few cases, perhaps there are other situations that will need to adjust the formula