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 :
FINRA |
GLEIF |
BVD |
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