Icon

Calculate period new or lost customer

v1 v2 DataTitle belowRow codeHeaderDateDate ascCalculate iflost or acquiredOne customerper iterationPrevious rowNext rowProvisionalrenamingNew nameFilteringcalculationcolumnsRenamingcustomerOne customerper iterationFilteringdateOne columnPrevious rowFilteringcalculationcolumnsCalculate iflost or acquiredPrevious rowclientRenamingBack to manycolumnsCustomerDate Table Creator Transpose Column Splitter RowID Insert ColumnHeader RowID Sorter Column Expressions Column ListLoop Start Lag Column Moving Aggregation Column Rename VariableExpressions Column Filter Column Rename Loop End (ColumnAppend) Column Filter Unpivoting Lag Column Column Filter Column Expressions Lag Column Column Rename Pivoting Sorter v1 v2 DataTitle belowRow codeHeaderDateDate ascCalculate iflost or acquiredOne customerper iterationPrevious rowNext rowProvisionalrenamingNew nameFilteringcalculationcolumnsRenamingcustomerOne customerper iterationFilteringdateOne columnPrevious rowFilteringcalculationcolumnsCalculate iflost or acquiredPrevious rowclientRenamingBack to manycolumnsCustomerDateTable Creator Transpose Column Splitter RowID Insert ColumnHeader RowID Sorter Column Expressions Column ListLoop Start Lag Column Moving Aggregation Column Rename VariableExpressions Column Filter Column Rename Loop End (ColumnAppend) Column Filter Unpivoting Lag Column Column Filter Column Expressions Lag Column Column Rename Pivoting Sorter

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: rbarri
Created at: 2022-11-18
On NodePit since: 2022-11-19
Last update: 2024-11-18
Created with KNIME version: v4.6.3

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

Try NodePit Runner!