Appending values utilizing two columns

Hello everyone,

This might be super easy but i can't seem to figure it out.

If column 1 has duplicate values but has a value of Y then all values of column 1 should be Y if it doesn't then it should be N

How can i code that? Formula tool?

Its tricky for me since its dependent off of the data in the second column all while duplicates exist in column 1

Thanks!

example.yxmd

Workflow

Help

Accepted answers

IraWatt

Hey @jgarcia0417,

There are a few ways to do this. What I would do is use a filter to find the Teams with Y. Then Join those teams back on but only Join the Y values from the right. Then the ones which don't join you can just apply "N"

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd

All comments

IraWatt

Hey @jgarcia0417,

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd

Luke_C

Hi @jgarcia0417

How's something like this?

Summarize tool to concatenate all the values for each team
Formula to check if it contains Y and apply your logic

example (1).yxmd

chuckleswk

It's really hard to tell what you are trying to accomplish here. It might help if you have an example of what you want the output to look like.

From what I can tell (correct me if I'm wrong), you are if any of those teams has a Y in the column then column 2 for all of that same value should have a Y....otherwise it's a N?

If that's the case, then you can use the following: .

example.yxmd

jgarcia0417

this worked and answered my question thank you IraWatt !

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703