multi row formula - how to use

[Bart_Esz]

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

[Emil_Kos]

Hi @Bart_Esz,

I have prepared multi row formula for you:

The output:

[atcodedog05 · Accepted solution]

Hi @Bart_Esz 

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 : )

[Bart_Esz]

hi atcodedog05,

thanks a lot, that's exactly what I needed

@Emil_Kos 

thank you a lot for your reply

take care, Guys

[atcodedog05]

Happy to help : ) @Bart_Esz 

Cheers and have a nice day!