If Conditional statement - 3 fields

I would like to write a conditional statement with just three columns. i imagine this is simple but my newbie skills just aint there yet

If any record in field Name has "Outlier" in field Check, all like records in field Name should have "Yes" in field Yes/No.

All others should have "No".

So, because there are three "Outlier" records for C, all C records 10-12 should then have "Yes" in column 3 (and every instance of A, B, and C below the sample)

Because XXX has no "Outlier" results, all XXX rows should read "No" in column 3

Preparation

Accepted answers

DataNath

Is this what you're after @Make_It_Raynes? This may fail if your [Check] column has other options than 'Outlier' or blank so please let us know if so:

Yes or no flag from Outlier.yxmd

All comments

IraWatt

Hey @Make_It_Raynes,

Here is one way of doing this:

The Summarize Tool to group each Name and Check value. I then filter to only the Name values which have a Check value Outlier. I then only join on Names with a Check Outlier applying a yes value to them. The ones which did not join i apply No.

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd

DataNath

Is this what you're after @Make_It_Raynes? This may fail if your [Check] column has other options than 'Outlier' or blank so please let us know if so:

Yes or no flag from Outlier.yxmd

FreeRangeDingo

You can do this with a summarize, formula, and a join. See attached workflow. The first set of tools used your data set. In the second set of tools, I expanded the data set a bit to make sure it was doing what I expected.

The summarize concatenates all values in the Check column for each name. The Formula tool looks to see if "Outlier" is contained in that concatenated value. The join gives a new Yes No column from the Formula.

Community problem.yxmd

Make_It_Raynes

@DataNath

this worked great, thanks so much... easy to follow and the results im after ('outlier' or null are the only field results so yes it is good to go)

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703