Forum Discussion
How can I replace single value
Do you mean a single value for a specific row?
I would create a temporary conditional column that looks for a combination of that value and some other grouping of field values on that row that make it unique. Then create a second column that keeps the value if the result of the first column is false and changes it when true. Then delete the old column along with the first calculated column. Might look something like this:
Check column: if [Other Party] = "ACCOUNT FEE" and [RecID] = "12345" then True else False
New Other Party Column: if [Check Column] = True then "Replacement value" else [Other Party]
As of right now, I do not think there is a one step solution to this issue. I have not found functionality in the transform tab to place a single value coresponding to one row and column.
A solution I used to get around this was to create a custom column with the following:
If [value column you want to change] = [unique row identifier (primary key)] then "value you want to change", else [value column you want to change]
notice in this solution you must have a primary key to identify the row you would like to change.
I hope this helps