Formula Exel transform

May I know how can i do the formula below in Alteryx. Need some help.

IF(L2<>L1,1,H1+1)

Developer

Accepted answers

you need to use the multi row formula toool

If [field] != [row-1:field} then 1 else [row+1:parent_row_key] endif

@hzpetro Let me know how you get on.

Ash

you need to use the multi row formula toool

If [field] != [row-1:field} then 1 else [row+1:parent_row_key] endif

@hzpetro Let me know how you get on.

Ash

You may use Multi-Row Formula tool.

Configuration

Expression in the tool

IF [Row-1:immed_parent_item] != [immed_parent_item]
THEN 1
ELSE [Row-1:parent_row_key] + 1
ENDIF

You may also want to check this interactive lesson. Good luck

Thanks for the advise and sharing knowledge. Really appreciate it