Icon

Association Rules - Solution

hshld & tnsct count Create lookup table for "category names" to"category numbers" Association rules Sort Top Rules on basket by Lift readre_hw_data Rule engine to fixblank and NULLcategory = "NULL" Remove category= "NULL" Transformcategorynames tonumbers Create RuleID and ungroupAntecedents Convert column "category_name (tonumber)" to string Join Antecedent to category_name(to number) column Group by per RuleID and ConcatenateAntecedents, category_names columns; Join Consequent to correspondingcategory_name fix NULLNode 3Transform categorynames to numbersFilter category name and numbercheck they are uniqueConcatenate_transactionsTransform to listNode 13Node 14Node 15Node 16Node 17Node 18Node 19Node 20Top rulesfor "lift" valuereadre_hw_datafilter NULLgenerate association rules Rule Engine GroupBy Category to Number Column Filter GroupBy GroupBy Cell Splitter RowID Ungroup Number To String(deprecated) Joiner (deprecated) GroupBy Column Rename(deprecated) Joiner (deprecated) Column Rename(deprecated) Sorter File Reader Rule-basedRow Filter AssociationRule Learner hshld & tnsct count Create lookup table for "category names" to"category numbers" Association rules Sort Top Rules on basket by Lift readre_hw_data Rule engine to fixblank and NULLcategory = "NULL" Remove category= "NULL" Transformcategorynames tonumbers Create RuleID and ungroupAntecedents Convert column "category_name (tonumber)" to string Join Antecedent to category_name(to number) column Group by per RuleID and ConcatenateAntecedents, category_names columns; Join Consequent to correspondingcategory_name fix NULLNode 3Transform categorynames to numbersFilter category name and numbercheck they are uniqueConcatenate_transactionsTransform to listNode 13Node 14Node 15Node 16Node 17Node 18Node 19Node 20Top rulesfor "lift" valuereadre_hw_datafilter NULLgenerate association rulesRule Engine GroupBy Category to Number Column Filter GroupBy GroupBy Cell Splitter RowID Ungroup Number To String(deprecated) Joiner (deprecated) GroupBy Column Rename(deprecated) Joiner (deprecated) Column Rename(deprecated) Sorter File Reader Rule-basedRow Filter AssociationRule Learner

Nodes

Extensions

Links