How to do the multiple formula for multiple column and rows

[luo]

Hi Guys,

I am working on a project that will need a specific logic. I have a feeling that alteryx should be able to do this but I'm not sure. I was trying to use multiple formular but I don't know how to involve row and column together.

The general logic is:

If Column B = Column C, then output "1" to the field corresponding to Column A.

If not, then nothing. (like row 10 )

I was thinking maybe setup a varible of column A?

Below is the output. 

Can you tell me if this can be done or not? Thank you so much. I have upload this output as well. The input is the same sheet without "1"

[RolandSchubert · Accepted solution]

Hi @luo 

I think, you can use the Multi-Field Formula tool with nested conditions in the formula to check, if column B = column C and to assign the "1" to the right column. I've attached a sample workflow.

Let me know if it works for you.

Best,

Roland