Alteryx Designer Desktop Discussions

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

Comparing Records in same column and with other columns

mfulara
5 - Atom

I want to find and create a new column for the records in which Item Code is the same and Location is different, and then compare the value of Days w/o Consumption column for that case. The most value should get the least value's Location name.

2 REPLIES 2
TimN
13 - Pulsar

Something like this may work...

mfulara
5 - Atom

Thanks tim it works.

Labels
Top Solution Authors