Icon

RFM_​Analysis_​09May2026

CSV Reader
Removing time from the InvoiceDate
String Manipulation
To convert String to Date datatype, the format does not change to the given format.
String to Date&Time
Group Date
GroupBy
For RFM, we can use a cut off date, and find the number of days
Date&Time Difference
InvoiceValue= Unit Price * Quantity.If there is a negative value, that represent product returned
Math Formula
Get Unique Invoice((Frequency) for each customer, Add Invoice values(Monetory), Find min date diffeernce(Recency)
GroupBy
Binner
Remove missing customer or Invoice sum less than 0
Row Filter
Rule Engine
Column Renamer
Column Appender
Rule Engine
Rule Engine
Column Resorter
Excel Writer

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: pprachitesh
Created at: 2026-05-09
On NodePit since: 2026-05-24
Last update: 2026-05-24
Created with KNIME version: v5.11.0

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

Try NodePit Runner!