Start Free Trial

Alteryx Designer Desktop Discussions

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

Substitution of Data in Alteryx

PNiccolo
7 - Meteor

Hi everyone!
I found myself in a situaiton like this:

CountryItem CodeUnit CostMinMax
Egypt5060100.10.11.000043,53No MinNo Max
Egypt5060100.10.11.000042,66No MinNo Max
Egypt5060100.10.11.000043,3536

 

What I want to do is to substitute the first two rows that show "No Min" and "No Max" with the values on the third row.
I want to do this based on the Item Code, so every time I have an item code that has some numbers in the Min and Max columns and the same item code that shows "No Min" and "No Max" I want to substitute these with the values.

Do you know a way to do this?

Thank you very much in advance!

2 REPLIES 2
LukeM
Alteryx Alumni (Retired)

Captsure.JPG

PNiccolo
7 - Meteor

Thank you very much!

Labels
Top Solution Authors