Emulate the PLSQL (partition) in DV?

Question

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

loret-JavaNet · Answer

You can also use Data Flow with a Cumulative value step. It allows to choose your sorts.

loret-JavaNet · Answer

Hi,

Have you tried something like this in a calculation :

rcount(PO_PO_ID by  v_BUSINESS_UNIT, v_VOUCHER_ID)