Forum Discussion
Conditional Table.ReplaceValue (if to define it replace will be applied or not)
Hi I have query with 3 columns: InvoiceNumber, InvoiceType and InvoiceAmount. There are 40K+ records, and half a dozen of them have the wrong InvoiceType (need to change com "Service" to "Product...
I believe you can also create a quick table of replacements and then merge the 2 fields of both tables
| InvNumber | InvType | Correct Replacement |
| 30881 | Service | Product |
| 30769 | Service | Product |
| 30770 | Service | Product |
Zubair, that seems to be the easier way to go, thanks for that. I'll use it, because in the end of the day, it solves the problem.
In the meantime I really wanted to improve my "IF" skills. This "do nothing' at the end of the if then else statement is really troublesome. Let's see if somebody come up with an insight on that.
Best regards,