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]
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]
I have the same question please.
Here is my situation Cfarinha.
I have an orders table that looks like this:
ORDERID AMOUNT
1 100
2 159
3 400
4 543
How can I change it so that in the AMOUNT column, for ORDERID 2 the AMOUNT is changed to 60?
I tried creating a custom column that looked like this:
(IF [ORDERID] = 2 then AMOUNT = 60 ELSE AMOUNT = AMOUNT)
This did not work and returned boolean values in the custom column.
Ideally I just want to change it in the AMOUNT column directly for the specific row. How can that be done?
Based upon your solution above, would it work for me? Where does the RecID value come from?
Thanks.
ianwuk