What I am having at the moment is:
1. A table with Direct Debit transactions, with amounts and date of the transaction and the customer id.
2. A table with a complete history of all transactions of all customers
What I now need to add to the first table is the total EURO_AMOUNT of the customer taken into consideration of all transactions that took place before the direct debit (so based on the date insert of the direct debit). So, I need some sort of sumif(historical transaction has same customer id and date insert id before the date insert of the direct debit).
I am pretty sure that I need the transform node to do this, but don't know how. Could you help me out please?
Please sign in to leave a comment.