Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
Emulate the PLSQL (partition) in DV?
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 , CloudCode 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
Tagged:
0