Hi Team,
Hope you are well.
Can you please help me in understanding the below forumla?
if [Row-1:ctr_key]=null()
then 1
elseif ([value]=[Row+1:value] and [value]=[Row-1:value]) or ([value]=[Row-2:value] and [Row-1:COMPARE]=1)
then 1
elseif [Value]=[Row-1:Value]
then 1
else 0
endif
Thanks for the help.
Sri
This formula is checking for certain conditions, If any of these conditions are true for a particular row, it returns 1; otherwise, it returns 0.
Refer to the below explanation:-
1. Check if the Previous Row's "ctr_key" is Null: If the "ctr_key" value in the previous row is null (empty), then return 1.
2. Check for Specific Patterns in Adjacent Rows:
If the value in the current row is the same as the value in the next row AND the same as the value in the previous row, OR
If the value in the current row is the same as the value two rows back AND the "COMPARE" value in the previous row is equal to 1, then return 1.
3. Check if Current Value is the Same as Previous Row's Value: If the value in the current row is the same as the value in the previous row, return 1.
4. If None of the Above Conditions are Met: If none of the conditions mentioned above are met, return 0.
Thanks,
if [Row-1:ctr_key]=null() then 1
elseif ([value]=[Row+1:value] and [value]=[Row-1:value]) or ([value]=[Row-2:value] and [Row-1:COMPARE]=1) then 1
elseif [Value]=[Row-1:Value] then 1
else 0 endif
Perfect Thanks @Aishw1990
Perfect Thank you @binuacs
@binuacs is there a learning material or a link to learn about these tools please if you can suggest.
https://help.alteryx.com/current/en/designer/tools.html
@sriniprad08 - there is a help page on Alteryx.com for all the tools. I'd also suggest the example workflow which you can get to by hovering on the tool on the Preparation Tool Ribbon in Designer and hitting the 'Open Example' link