Multi-row formula flag change in multiple columns

[Andreas92]

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

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

[Christina_H · Accepted solution]

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.

[Andreas92]

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

Many thanks!

Andreas

[atcodedog05]

Hi @Andreas92 

Same goes for me I thought you wanted to also highlight C in red and complicated things 😅

Cheers and have a nice day!🙂