Hi, I have transactions table, with in and out operations. Columns: date, quantity, part number, type (in, out), operation number.
So i want to cut out on load paired transactions that has the same quatinty, but are opposite to each other.
I made it out to mark the ones that accur on the same day (daily sum = 0), and avoid loading them (table with items where daily sum is <>0, then left keep load)
as example, I want to load only the yellow marked line. 5 and -5 give 0.
Is it possible? Thanks in advane for any reply.
