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
History | Fiction | Kids | |
Books | 0 | 13 | 34 |
Solved! Go to Solution.
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
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