I have a transaction level data of 10000 rows where each customers have done more than 2 transactions. I want to check whether a customer has done transaction in recent 6 months how can I do that in calculator component?

Matillion ETL
1

I am not able to do a group by in calculator component?

Whenever I try to use sum, count I am getting thins error:-

["values".SNDCUSTOMER_KEY] is not a valid group by expression

 

2

share more details like column to be used (with datatype) and sample input output, so we can help you with this.

3

I dont think you can achieve this directly in Calculator component. You might need to use a Row Number WINDOW function to identify the transection no. And then filter on this new column.

4

Thanks, was able to do that by using calculator and aggregate function.