Alteryx Designer Desktop Discussions

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

Update Column value if other column has the same values

Alteryxte
5 - Atom

Hi all,

 

I want to update a column if other columns contains the same value. I uploaded the input, and an output I desire. Thank you all very much for the help in advance!

 

Basically if both Column A - Auditor/BU and the Date columns are the same and they contain a complete status, then replacing Missing/Under Investigation Status to Complete status.

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @Alteryxte using the Multi-Row tool will help you achieve your desired results.

 

Multi_Row_17012024.JPG

Alteryxte
5 - Atom

Hi @JosephSerpis,

 

Thank you so much for your speedy response! I tried Multi-Row tool and didn't work. I guess I didn't know that I can use the group function for this tool. This worked for me! Thank you so much again!

Labels
Top Solution Authors