We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Discussions

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

Replacing text in one column that is different based on another column being the same

Gr4c3B4ss
7 - Meteor

Hi Community,

 

Here is my puzzle...

 

If any of the same vendor IDs say No then all the other rows for the same vendor ID need to say No as well

 

 

Thank you in advance for your help 🙂

 

Grace

4 REPLIES 4
danilang
18 - Pollux
18 - Pollux

Hi @Gr4c3B4ss 

 

Just to be clear, using your sample data, all the values in the campaign column will be "No" since since all vendors have at least one "No".  Is this correct?  If not, please provide the output that you require and any specific rules.

 

Dan

cmcclellan
13 - Pulsar

I made the new value NO so you can see the difference 🙂 

 

cmcclellan_0-1630281340570.png

 

Gr4c3B4ss
7 - Meteor

Hi @danilang 

 

Sorry for the confusion.  The actual data set I am using has thousands of rows with some Vendors that will be all yes and some will be all no.  There are hundreds of vendors that have a combination of yes and no and those need to be changed to all no while not changing the other vendors that have all yes and all no.

 

Grace

Gr4c3B4ss
7 - Meteor

@cmcclellan,

 

Thank you sooo much!!!! Worked perfectly 🙂 I will be applying the logic of this workflow to many problems!  You saved me countless hours. 

 

Grace

Labels