Icon

Iteratively Processing Donations and Expenses

Donations and Costs based on workflow for assigning expenses to budgets

Below - Java Snippet Version - assigns all costs to all possible purchase orders for a given WO, and thenuses java snippet to determine which to assign costs to and which to discard Sample DataCheck totalPO BudgetsRename totxn seqTransactionsRename totxn seqget a sequence numberfor transactionsget a sequence numberfor transactionsSort by budget and transactionCumulativelyassign txn toPO and mark rowsfor deletion where exhaustedRemove rowsmarked fordeletionTidy upTidy upTidy upSample DataSample DataNode 87Creates a constant"WO"(work order) columnto satisfy original java snippetCheck total is still sameCheck totalExtract Data Tablefrom Delimited Text GroupBy Table Creator Column Rename Table Creator Column Rename Counter Generation Counter Generation Sorter Java Snippet Row Filter Column Filter Column Resorter Column Rename Extract Data Tablefrom Delimited Text Extract Data Tablefrom Delimited Text Cross Joiner ConstantValue Column GroupBy GroupBy Below - Java Snippet Version - assigns all costs to all possible purchase orders for a given WO, and thenuses java snippet to determine which to assign costs to and which to discard Sample DataCheck totalPO BudgetsRename totxn seqTransactionsRename totxn seqget a sequence numberfor transactionsget a sequence numberfor transactionsSort by budget and transactionCumulativelyassign txn toPO and mark rowsfor deletion where exhaustedRemove rowsmarked fordeletionTidy upTidy upTidy upSample DataSample DataNode 87Creates a constant"WO"(work order) columnto satisfy original java snippetCheck total is still sameCheck totalExtract Data Tablefrom Delimited Text GroupBy Table Creator Column Rename Table Creator Column Rename Counter Generation Counter Generation Sorter Java Snippet Row Filter Column Filter Column Resorter Column Rename Extract Data Tablefrom Delimited Text Extract Data Tablefrom Delimited Text Cross Joiner ConstantValue Column GroupBy GroupBy

Nodes

Extensions

Links