How to use both aggregate and analytic function in ODI

User_XG491

Hi All,

I am working on ODI mapping where I am calculating" Min(ID) over parition by(device_num, sys_id) as min_id" in expression component, I used another expression component to filter duplicates using row_number over partition by (ID) order by(min_id) this reaults in window function error. followed by a filter "rownum=1"

I understand that I need to run the analytical function on top the aggregate results. I am not sure how to achieve this in odi 12c. can anyone of you please guide me?

ID, DEVICE_NUM, SYS_ID

im trying to achieve