Explanation of multi row formula

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

Expression

Accepted answers

All comments

Aishw1990

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,

binu_acs

@sriniprad08

if [Row-1:ctr_key]=null() then 1
- If the value in the ctr_key column of the previous row is null, assign 1.
elseif ([value]=[Row+1:value] and [value]=[Row-1:value]) or ([value]=[Row-2:value] and [Row-1:COMPARE]=1) then 1
- If the current row's value is equal to both the next row's and the previous row's value, or if the current row's value is equal to the value two rows back and the previous row's COMPARE column is 1, assign 1.
elseif [Value]=[Row-1:Value] then 1
- If the current row's Value is equal to the Value in the previous row, assign 1.
else 0 endif
- If none of the above conditions are met, assign 0.

sriniprad08

Perfect Thanks @Aishw1990

sriniprad08

Perfect Thank you @binu_acs

sriniprad08

@binu_acs is there a learning material or a link to learn about these tools please if you can suggest.

DanielG

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

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703