We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Comparing columns to generate new column

NY2BOS
7 - Meteor

Hi all. 

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

For Example,

 Project 1Project 2Project 3Project 4Overlap

Asset A

X X YES
Asset B XX YES
Asset C X XYES
Asset D  XXYES
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.

1 REPLY 1
Luke_C
17 - Castor
17 - Castor

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

 

Luke_C_0-1648819827240.png

 

 

Labels
Top Solution Authors