Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 182 Oracle Analytics News
- 39 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 62 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
Emulate the PLSQL (partition) in DV?

Brian666H
Rank 6 - Analytics Lead
Summary
Is there a way within the DV tool to emulate the PLSQL (partition)?
Content
Is there a way within the DV tool to emulate the PLSQL (partition)? row_number() over (partition by v_BUSINESS_UNIT, v_VOUCHER_ID order by v_BUSINESS_UNIT, v_VOUCHER_ID) rn
Data Flow?
Version
18 , Cloud
Code Snippet
select V_BUSINESS_UNIT ,V_VOUCHER_ID ,PO_PO_ID ,v_entry_status ,V_GROSS_AMT amt ,V_FREIGHT_AMT ,V_MISC_AMT , row_number() over (partition by v_BUSINESS_UNIT, v_VOUCHER_ID order by v_BUSINESS_UNIT, v_VOUCHER_ID) rn FROM FACTTable where v_entered_dt > '31-DEC-2017' and po_po_id is not NULL and po_po_id <> ' ' and po_po_id <> '(null)' group by V_BUSINESS_UNIT ,V_VOUCHER_ID ,PO_PO_ID ,v_entry_status ,V_GROSS_AMT ,V_FREIGHT_AMT ,V_MISC_AMT
0
Answers
-
Hi,
Have you tried something like this in a calculation :
rcount(PO_PO_ID by v_BUSINESS_UNIT, v_VOUCHER_ID)
0 -
You can also use Data Flow with a Cumulative value step. It allows to choose your sorts.
0