community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

How can I change the entry for one specific cell?

Fireball

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.  

 

Thanks

 

 HistoryFictionKids
Books01334
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]

endif

 

 

Alteryx Partner

@hellyars

 

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

Labels