Icon

Rebate AR Kenneth

Rebate_Ar WorkflowLast Edited: 5/28/2025Last Edited by: Kenneth AguilarPurpose: -Determine which items are in fact for Rebate. Clean up originalfile while adding useful information like Credits/Debits.Edit Notes:- Converted two Engine Rule nodes into one Column Expressionsnode (Kenneth)Future Goals:- Find a way to schedule run - will probably need Knime Hub-Find a way to pull data from server avoiding user to constantlypull and run data on local machine OLD NODES ResortsColumnsAdds DebitsRule & ColumnAdds CreditsRule & ColumnResortsColumnsReads SourceExcel FileNode 27Deletes LastRow (Totals)Combine Doc #and Line item #Remove Prod inv, non-rebate Rsn Codes, andnon-rebate cred memosAdds SIIComments Col.Adds Credit & Debit columns Column Resorter Rule Engine Rule Engine Column Resorter Excel Reader Excel Writer Row Filter Column Combiner Rule-basedRow Filter ConstantValue Column Column Expressions Rebate_Ar WorkflowLast Edited: 5/28/2025Last Edited by: Kenneth AguilarPurpose: -Determine which items are in fact for Rebate. Clean up originalfile while adding useful information like Credits/Debits.Edit Notes:- Converted two Engine Rule nodes into one Column Expressionsnode (Kenneth)Future Goals:- Find a way to schedule run - will probably need Knime Hub-Find a way to pull data from server avoiding user to constantlypull and run data on local machine OLD NODES ResortsColumnsAdds DebitsRule & ColumnAdds CreditsRule & ColumnResortsColumnsReads SourceExcel FileNode 27Deletes LastRow (Totals)Combine Doc #and Line item #Remove Prod inv, non-rebate Rsn Codes, andnon-rebate cred memosAdds SIIComments Col.Adds Credit & Debit columns Column Resorter Rule Engine Rule Engine Column Resorter Excel Reader Excel Writer Row Filter Column Combiner Rule-basedRow Filter ConstantValue Column Column Expressions

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: z0043dwn
Created at: 2024-03-12
On NodePit since: 2025-05-31
Last update: 2025-06-01
Created with KNIME version: v4.7.5

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!