3 condition If formula
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Masond3
8 - Asteroid
‎11-04-2021
04:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 ;
& the other Source is either "None" Or "Null"FINRA GLEIF BVD - 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"
- If "Count of Group" = 2 and within that group, one row has a Source Populated of ;
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
Labels:
- Labels:
- Common Use Cases
2 REPLIES 2
16 - Nebula
‎11-04-2021
05:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Christina_H
14 - Magnetar
‎11-04-2021
07:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/12DF86F0CA96E81F3ABF675C1590B6DD/responsive_peak/images/icon_anonymous_message.png)