BlazkoG
Contributor III
2021-02-08
10:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
selective data load, advanced load filter
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.
685 Views
0 Replies