Conditional Function with Dependency

I am trying to create a condition that would be dependent on each AccountID value. Where if the user has the ADMIN permission directly on the ORG name, then any additional rows for that user would be removed in the output (since having ADMIN at the ORG level already encompasses all other permissions).

For example:

In the input sample below, the desired output would exclude Rows 2, 4, 5, and 6.

Workflow

Output

Transformation

Preparation

Accepted answers

DavidP

Hi @tbezold

I've updated the if statement in the multi-row - try this version out.

remove non admins.yxmd

All comments

lmorrell

Hi @tbezold

Workflow is attached.

Conditional Function with Dependency.png

By flagging AccountIDs that are admin ([Host] = 'ORG:UWD' AND [Permission] = 'ADMIN') with a value of 1, we can use the Summarize tool to Group By Account ID and adjust the flag to remove all the rows that are not specifying the Admin permission via a Join back to the original dataset. This felt a bit abstract to type out so it might not make sense, but please check the workflow and let me know if you have any questions 🙂

Hope this helps!

Conditional Function with Dependency.yxmd

DavidP

Hi @tbezold

I would use a multi-row formula to flag the rows to be removed and then remove them with a filter tool, like this:

remove non admins.yxmd

tbezold

I probably should have specified that there are multiple ORG names in the main input file. When running the multi-row formula that you provided against the main input file (which contains multiple ORG names), the output only shows users as having ADMIN on one ORG when that actually have ADMIN on multiple ORGS.

To show this, I added two rows additional rows with a 2nd ORG for BUE to show this below (and attached workflow). Any thoughts?

remove non admins.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703