Icon

User Persona Identification

Data Extraction O/P Data to Postgres Clustering Clustering Connecting to DBGetting the stn_idsCreating 2 clustersAppending the tablewith new cluster valuesRemoving Normalized ColumnDiscarding userwho is not a playerCreating three clustersAppending the tablewith new cluster valuesConnecting the datatbaseInserting the data to DBIf there are lessthan 50 rowsit will stop hereIf there are lessthan 100 rowsit will stop hereStarting the loop for each stin_idGrouping as per each clusterCalculating theaverage valueAssign labelfor each level ofplayerGetting themax valueGetting themin valueAdding player_levelcolumn based onclusteringCalculating theaverage valueAssigning labelfor player & non-playerGrouping as per each clusterGetting themax valueAdding is_playercolumn for each customerEnding the loopand getting the tableGetting Raw Datafrom two tablesSelecting transaction_detail_old tableReading dataIntermediate TableReading dataGroupingFinal TableNode 122 PostgreSQLConnector Value Counter k-Means Column Appender Column Filter Row Filter k-Means Column Appender PostgreSQLConnector DB Insert End IF End IF Table Row ToVariable Loop Start GroupBy Math Formula Rule Engine Math Formula Math Formula Joiner Math Formula Rule Engine GroupBy Math Formula Joiner Loop End DataPreparation1 DataPreparation2 DataPreparation3 DB Table Selector DB Table Selector DB Reader Joiner DB Reader GroupBy Column Rename PMML Writer DB Insert Data Extraction O/P Data to Postgres Clustering Clustering Connecting to DBGetting the stn_idsCreating 2 clustersAppending the tablewith new cluster valuesRemoving Normalized ColumnDiscarding userwho is not a playerCreating three clustersAppending the tablewith new cluster valuesConnecting the datatbaseInserting the data to DBIf there are lessthan 50 rowsit will stop hereIf there are lessthan 100 rowsit will stop hereStarting the loop for each stin_idGrouping as per each clusterCalculating theaverage valueAssign labelfor each level ofplayerGetting themax valueGetting themin valueAdding player_levelcolumn based onclusteringCalculating theaverage valueAssigning labelfor player & non-playerGrouping as per each clusterGetting themax valueAdding is_playercolumn for each customerEnding the loopand getting the tableGetting Raw Datafrom two tablesSelecting transaction_detail_old tableReading dataIntermediate TableReading dataGroupingFinal TableNode 122PostgreSQLConnector Value Counter k-Means Column Appender Column Filter Row Filter k-Means Column Appender PostgreSQLConnector DB Insert End IF End IF Table Row ToVariable Loop Start GroupBy Math Formula Rule Engine Math Formula Math Formula Joiner Math Formula Rule Engine GroupBy Math Formula Joiner Loop End DataPreparation1 DataPreparation2 DataPreparation3 DB Table Selector DB Table Selector DB Reader Joiner DB Reader GroupBy Column Rename PMML Writer DB Insert

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: Suprio Dutta
Created at: 2020-07-20
On NodePit since: 2020-07-24
Last update: 2024-11-21
Created with KNIME version: v4.1.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!