Icon

c2.2_​1_​Generate_​Orders_​and_​Churns

There has been no title set for this workflow's metadata.

c2.2_1_Generate_Orders_and_Churns

Generate synthetic data and explore and analyze millions of rows of data with Sqlite, without needing a real Big Data database environment.
In this example we will generate a customer file with orders and churn cases and join them together to search for "soft churner".
For more details read the article "Generate Synthetic Customer Data with KNIME and SQLite”(see link below).

URL: Generate Synthetic Customer Data with KNIME and SQLite https://deganza11.medium.com/big-data-for-the-poor-man-how-knime-and-sqlite-helped-in-the-fight-against-soft-churner-efcf2f558dab

Generate customer file Generate orders and churn files Write files in SQlite database and indexing Node 17clientsdbchurnerDateOrder Datechurnerno/yesMerge data setsChurn_Dateorder againNode 35Node 36order withother idyes/noJan-JulAug-Dezchurnerno/yesorder againMerge data setsNode 48Node 49Node 50Node 54Node 56Node 57orderschurnerNode 62client indexclient indexNode 65Generateaddress data Generate customer SQLite Connector MISSING RandomLabel Assigner Create Date&TimeRange Column Rename(deprecated) Row Splitter MISSING RandomMatcher Column Rename(deprecated) MISSING RandomLabel Assigner Concatenate Missing Value Row Splitter Date&Time-basedRow Filter Date&Time-basedRow Filter Row Splitter Row Filter MISSING RandomMatcher Concatenate InteractiveTable (legacy) Column Filter Concatenate Column Filter Column Filter DB Writer DB Writer replace names DB SQL Executor DB SQL Executor Joiner Generate customer file Generate orders and churn files Write files in SQlite database and indexing Node 17clientsdbchurnerDateOrder Datechurnerno/yesMerge data setsChurn_Dateorder againNode 35Node 36order withother idyes/noJan-JulAug-Dezchurnerno/yesorder againMerge data setsNode 48Node 49Node 50Node 54Node 56Node 57orderschurnerNode 62client indexclient indexNode 65Generateaddress data Generate customer SQLite Connector MISSING RandomLabel Assigner Create Date&TimeRange Column Rename(deprecated) Row Splitter MISSING RandomMatcher Column Rename(deprecated) MISSING RandomLabel Assigner Concatenate Missing Value Row Splitter Date&Time-basedRow Filter Date&Time-basedRow Filter Row Splitter Row Filter MISSING RandomMatcher Concatenate InteractiveTable (legacy) Column Filter Concatenate Column Filter Column Filter DB Writer DB Writer replace names DB SQL Executor DB SQL Executor Joiner

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: degan
Created at: 2021-10-07
On NodePit since: 2023-12-02
Last update: 2024-04-27
Created with KNIME version: v5.1.2
Tags: big datasqlitedata engineeringchurnsynthetic data

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

Try NodePit Runner!