3 condition If formula

[Masond3]

HI All, 

I need some assistance, i can explain what i want with examples but struggling to formulate this into alteryx logic. 

Using the the example below i need some help building out an "outcome column"

The logic to drive the value in the "Outcome Column" Is as follows  ;

NB : 

• Only assess values within a group
  
  • If "Count of Group" = 2 and within that group, one row has a Source Populated of ;

    FINRA

    GLEIF

    BVD

    & the other Source is either "None" Or "Null" 
  • Then I want the on the row of the record with the Source Populated for that given group to have the word "Master" populated in column called "Outcome" 

Group	Count of Group	Name	ID	Source	Outcome	Master Id
100	2	Mason LTD	0013a00001a55fgAAA	FINRA	Master	0013a00001a55fgAAA
100	2	Mason LTD	0013a00001pjDhyAAE	None		0013a00001a55fgAAA
101	2	Mason LTD	0013a00001a83U0AAI	FINRA	Master	0013a00001a83U0AAI
101	2	Mason LTD	0013a00001pjDVLAA2	[Null]		0013a00001a83U0AAI
102	2	Mason LTD	0013a00001aLfM0AAK	GLEIF	Master	0013a00001aLfM0AAK
102	2	Mason LTD	0013a00001pjFwrAAE	[Null]		0013a00001aLfM0AAK
103	2	Mason LTD	001j000000sSOEXAA4	[Null]		0013a00001aayzQAAQ
103	2	Mason LTD	0013a00001aayzQAAQ	BVD	Master	0013a00001aayzQAAQ

Looking forward to your assistance

Kind Regards
Masond3

[ChrisTX]

This option isn't the most efficient because it uses a cartesian join, but it avoids a batch macro.

Chris

[Christina_H]

Here's my take: