Forum Discussion
Advocate IIICorrecting a number value in data
Hi,
I am trying to correct a number value that was entered incorrectly in the database. I am basically using the add custom but not sure why it's not working.
Am I do something incorrectly? Thanks!
Hi Rsanjuan,
So you want to replace current value based on other columns, right?
If this is a case, you can try to add a custom steps and use below formula:
ReplaceValue= Table.ReplaceValue(#"Changed Type",each [Bid Value V2],each if [Job.Name] = "S0S17800487" then 78570 else [Bid Value V2] ,Replacer.ReplaceValue,{"op_id"})Sample:
Reference link:
Query editor replacing values based on another columnRegards,
Xiaoxin Sheng
4 Replies
- bdymit
Resolver II
I don't believe that you can edit the numbers within a column by creating another custom column.
I would do this:
=if [Job.Name]="SOS17800487" then 78570 else [Bid Value v2]
So it would copy all of the values from [Bid Value v2] except when the [Job.Name] is equal to SOS17800487. Then it would use 78570.
Then you can delete [Bid Value v2]
I am assuming that you want 78570 as a numerical value. If you want it as a text value, then you have to place it within quotation marks.
Let me know if this helps!
Hi Rsanjuan,
So you want to replace current value based on other columns, right?
If this is a case, you can try to add a custom steps and use below formula:
ReplaceValue= Table.ReplaceValue(#"Changed Type",each [Bid Value V2],each if [Job.Name] = "S0S17800487" then 78570 else [Bid Value V2] ,Replacer.ReplaceValue,{"op_id"})Sample:
Reference link:
Query editor replacing values based on another columnRegards,
Xiaoxin Sheng
