Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need some help in my load script. I am loading invoice headers and then joining the lines where my amount field gets read from. However, I want to exclude all invoices where the Sum(Amount) = 0.
What is the best way to approach this?
I have tried loading all into a temp table, then loading the fact as a resident from temp table where sum(Amount) > 0 and grouping by DocNumber. But it doesnt seem to work...
Any ideas?
@wcilliers can you share a sample data and the expected ?