Formula Tool

Question

Hi,

I have the following data:

Email                       Software Title              Answer

test@test.com         Tableau                       Yes

test2@test.com        Alteryx                         No

test3@test.com        Tableau                       No

test@test.com           Basic                          Yes

test4@test.com         Tableau                      Yes

Using a formula tool, how can I add a column to output the value "Split" for software titles that have both Yes and No for values under the Answer column. So with the data above, the output I would like would be the following:

Email                       Software Title           Answer            Split

test@test.com         Tableau                    Yes                  Split

test2@test.com        Alteryx                      No                   [Null}

test3@test.com        Tableau                    No                   Split

test@test.com           Basic                       Yes                  [Null]

test4@test.com         Tableau                   Yes                 Split

Tableau has the value Split in the Split column because it contains at least one Yes and at least one No as values in the Answer column (A software Title could have many Yes Values and many No values). Any help would be much appreciated. Thanks!

Claje · Accepted Answer

Hi,

I've attached an example of how to do something like this - you will need to change your input file to be your data source, but it should work.

Basically, I counted the distinct number of answers for each software title using a Summarize tool, then used a Formula to create the "Split" column, and joined back to the original data.

Hope this helps!