multi row formula - how to use

Dear All,

I'm new in Alteryx. I'm trying to replicate following excel IF statement into Alteryx, however still cant succeed.

It is about adding new ID if the value in TEXT column differs from the upper one.

I was trying to use the Multirow formula tool but couldn't succeed.

Could someone help me, please.

thanks

Accepted answers

I am guessing you are trying to create the ID column. You can configure like below.

Workflow:

You can also use tile tool setting config to unique value and setting unique value to text.

Hope this helps : )

I have prepared multi row formula for you:

The output:

I am guessing you are trying to create the ID column. You can configure like below.

Workflow:

You can also use tile tool setting config to unique value and setting unique value to text.

Hope this helps : )