Icon

Production-workflow

input month& CustomerIdAggregated info byCustomerIdCustomizingColumn namesClaculating %weekend & nighttransactionsSorting byspent amountdescAdding top spender ruleextracting 90percentilepassing the90 percentilevalueAdding weekend spender ruleFiltering CustomerAdding MonthExtracting Monthly DataDatabase Connector Container Input(Variable) GroupBy Column Rename Math Formula(Multi Column) Sorter Rule Engine GroupBy Table Rowto Variable Rule Engine Row Filter ConstantValue Column ContainerOutput (JSON) Table to JSON DB Query Reader Filter by month input month& CustomerIdAggregated info byCustomerIdCustomizingColumn namesClaculating %weekend & nighttransactionsSorting byspent amountdescAdding top spender ruleextracting 90percentilepassing the90 percentilevalueAdding weekend spender ruleFiltering CustomerAdding MonthExtracting Monthly DataDatabase Connector Container Input(Variable) GroupBy Column Rename Math Formula(Multi Column) Sorter Rule Engine GroupBy Table Rowto Variable Rule Engine Row Filter ConstantValue Column ContainerOutput (JSON) Table to JSON DB Query Reader Filter by month

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: diego.rodriguez
Created at: 2022-05-23
On NodePit since: 2022-12-22
Last update: 2024-04-27
Created with KNIME version: v4.6.1

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

Try NodePit Runner!