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)
![load.jpg load.jpg](https://community.qlik.com/t5/image/serverpage/image-id/48666i0FE898B00C12C579/image-size/large?v=v2&px=999)
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.