Categories
- All Categories
- 10 Oracle Analytics Sharing Center
- 13 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.6K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to use both aggregate and analytic function in ODI

User_XG491
Rank 1 - Community Starter
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
0