Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

How can I change the entry for one specific cell?


I want to change the specific entry for just one field.  


In the example below I just want to change the value for History from 0 to something.  




Alteryx Partner

A formula tool would do that, but how do you identify that row ?


From your example, I would say putting a formula on History that says:


If [F1] = "Books"

then 75

else [History]




Alteryx Partner



Here is an attached Workflow showing you how to do it.  It's the same solution as @cmcclellan , only I used a Filter Tool prior.


Let's us know if that helps x)

this is helpful - how would i then still export all the rows of data I have with the new changed field? Wouldn't this output only show the filtered "books" row