Looking to match values

Question

I recently joined to learn and improve my Alteryx skills and knowledge.

I am trying to create a column where it matches a particular value of a particular column in each row. Something like this:

I understand I would need to create a new column in the Formula Tool. But I don't see a match equation in there to get what I am looking for.

This is what I have done so far.

What do I need to do? I appreciate your help in this regard.

ryxnewbie · Answer

With the help of my colleague, I was able to create a column where it matches a particular value of the other columns by creating 2 formula tools.

Formula tool 1 updates the flag columns by changing values with string "No" to null and identifying non null values.

Formula tool 2 adds all the string non-null values of the flag columns together into one new column.

Now I need to count the string values of the new column into a Integration Count column. I tried doing a count by the new column and even tried grouping by the flag columns and new column as advised by @DanM, but it doesn't work. Is there a better way of counting the string values of the new column without transposing or cross tabbing?

ryxnewbie · Answer

@binuacs, this is sensitive data that my supervisors have not allowed me to share. However I can create mock sheets of the input and expected output result and share it.  Hope you're fine with that.

binu_acs · Answer

@ryxnewbie Can you provide the input file and expected output result?