Formula Exel transform

[hzpetro]

Hi

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

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

[aatalai · Accepted solution]

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.

Ta

Ash

[Yoshiro_Fujimori]

@hzpetro ,

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

https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872

[hzpetro]

Hi @Yoshiro_Fujimori & @aatalai 

Thanks for the advise and sharing knowledge. Really appreciate it