Hi all,
Hope you all doing well 🙂
I need your help guys...
I have a table with thousand rows. Several values in column Debits 2 and Credits 2 are not correct (you can refer to the highlighted cells).
Below is a screenshot of the table:
How can I change the value in Debits 2/Credits 2 into the right value?
I also attached a sampling of the data as a reference.
Thanks in advance and warm regards,
Devina
Solved! Go to Solution.
Here's my solution.
For exception handling, you can Filter out the case just to change the value for one row, and then Union it back with the rest of the data. To ensure everything is in the same order as before, use the RecordID tool at the start so that you have a field to sort your data on after using Union.
Thank you for the solution, it works for a small data size but if I have a large data (for example thousands rows or more), I don't think it will be very efficient to filter it one by one..is there any other way to change it without filtering it one by one?
How do you determine which values need to be changed? In your title you refer to the highest(largest?) value, but 20 is not the largest(nor the highest) value in the Credits 2 column. Once you have this defined, how do you pick which values to use as a replacement?
Is this based on a series of rules about the type of row(Credit/debit), some match between Account no 1 and Account no 2? Please be as detailed as possible
Dan