Hi Team, I have a query on splitting the row into two rows when there are amounts in both debit and credit accounts. If the amount is 0 on either account leave the row and don't split for the same batch ID. Please help me with the issue, I really appreciate it.
Here is an example:
Batch ID | Account ID | Account Name | Debit | Credit |
1001 | 20001 | Loan Account | 500 | 500 |
1001 | 20002 | Settle Account | 0 | 500 |
OutPut:
Batch ID | Account ID | Account Name | Debit | Credit |
1001 | 20001 | Loan Account | 500 | 0 |
1001 | 20001 | Loan Account | 0 | 500 |
1001 | 20002 | Settle Account | 0 | 500 |
Sounds like the suggestion by @IraWatt should work, but in case you wanted options here is another approach:
Good luck!