No, but Astera has a dedicated Distinct Transformation to filter out duplicate records from a dataset.
In the transformation, you can define an expression either from the library of built-in functions in the expression builder or write your own expression. You can also modify and use variables for various calculations in the expression transformation. Whereas in the transformation, you can only work with a set of built-in functions. You cannot modify or customize these built-in functions to suit your requirement, as you can do in the Expression transformation.
In the Aggregate Transformation, you can apply different aggregate functions such as Sum, Count, First, Last, Min, Max, Average, Var, or StDev and derive values from the input.
Whereas in Expression transformation, you can apply various functions such as string, date/time, financial, matching, logical, mathematical, regular expressions etc. on your incoming data or even write your own expressions in the expression layout builder.
The Aggregate Transformation is a set-level transformation which means that it can only take input from a single dataset. It creates derived values from input data. So, taking input from more than one source will result in cardinality error.
