Hi,
I have a question regarding below table. Kindly need a help to resolve it
Existing table
account | value in US |
50001 | -200 |
50002 | 200 |
3000 | -500 |
4500 | 500 |
45001 | 600 |
3000 | -600 |
how i can create desired below output from above table. account from Minus amount should come first corresponding second account positive and amount
account | sec account | currency |
50001 | 50002 | -200 |
3000 | 4500 | -500 |
3000 | 45001 | -600 |
Solved! Go to Solution.
Hi @rojan,
please find my solution attached:
Is that the solution you were looking for?
Best regards
Phil