Multi-row formula flag change in multiple columns

Hello,

I am trying to do something relatively simple but cant seem to do it in Alteryx.

See below screenshot, in yellow is a case where there was an entity change within a family, highlighted in red, and so I'd like to flag the whole family as "Entity changed?" = Yes.

In orange, is a case where the entities stayed consistent throughout the family, and flag as "No".

How can I generate this flag with Alteryx?

Thanks for your help!

Andreas

Preparation

Accepted answers

Christina_H

I might be missing something but I don't think you need a multi-row formula for this. I haven't added the formatting, but this produces the basic table.

EntityChange.yxmd

All comments

atcodedog05

Hi @Andreas92

Here is how you can do it.

Workflow: if you want only entity change

Workflow: if you want formatting on red color on entity change

Hope this helps : )

entity change.yxmd

Entity.yxmd

Christina_H

I might be missing something but I don't think you need a multi-row formula for this. I haven't added the formatting, but this produces the basic table.

EntityChange.yxmd

Andreas92

As easy as that! 🙂 was definitely complicating things for nothing.

Many thanks!

Andreas

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703