Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How can I change the entry for one specific cell?

hellyars
13 - Pulsar

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
3 REPLIES 3
cmcclellan
13 - Pulsar

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

 

 

Hakimipous
10 - Fireball

@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)

Talliford
5 - Atom

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