Comparing columns to generate new column

NY2BOS

Hi all. 

I am looking to make a new column value based on the data in other columns in a row. 

For Example,

	Project 1	Project 2	Project 3	Project 4	Overlap
Asset A	X		X		YES
Asset B		X	X		YES
Asset C		X		X	YES
Asset D			X	X	YES
Asset E		X			NO

Overlap would be the new column if 2 or more Projects have an X if only one project has an X it would say no. 

Thank you and I look forward to the solutions.

Luke_C

Hi @NY2BOS 

Here's how I would do this. This solution is dynamic in case more projects come into the dataset:

1. Transpose project data
2. Count non-null values
3. IF Statement to check if count is >=2 and assign overlap value
4. Join back to data

New Workflow2.yxmd