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"
Solved! Go to 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