This content has been marked as final. Show 2 replies
You cannot translate this kind of expression 1:1 into a script statement, because
- before and after are not available in your load script. There isn't even a function that comes close. You can however mimic this behavior using some pretty complex code, but that wouldn't be very efficient.
- there is no object with rows/columns to pick values before() / after(). There is just a single internal table with rows that you can GROUP BY into another table.
- in your expression you can easily aggregate fields from different tables, but in a script that would require explicit JOINS.
IMHO it would be better if you describe your internal table(s) in your data model and the expected output per set of GROUP BY fields. Would that be possible?