ABC

ABC component allows you to classify a dataset in three different groups of importance:
%%00009A: Most important
%%00009B: Average in importance
%%00009C: Least in importance

Example:

Step 1:
Identify the purpose of ABC-analysis. In this example we will classify the clientele based on annual turnover. All client that produce the 80% of the total turnover will be classified as A. Clients that produce the next 15% of the total turnover will be classified as B. All other clients will be classified as C. In this case the parameters must be set as: ID column = ClientID, Value column = Turnover, 1st Limit = 0.80 and 2nd Limit = 0.95. All next steps are executed by the ABC component automatically.

Step 2:
ABC component sorts the dataset in descending order based on client Turnover

Step 3:
ABC component calculates the total Turnover

Step 4:
ABC component calculates the Share of Turnover for each client

Step 5:
ABC component calculates the Running Total of Share

Step 6:
ABC component assigns the classification based on Running Total of Share

In addition, the ABC component provides and an interactive view which contains both output tables.

Options

ID column

Select a (string) or (integer) column with the IDs that will be used in ABC analysis

Value column

Select a (double) column with the Values that will be used in ABC analysis

1st Limit

Select the 1st (lower) Limit that will be used in ABC analysis (0 < 1st Limit < 1)

2nd Limit

Select the 2nd (upper) Limit that will be used in ABC analysis (1st Limit < 2nd Limit < 1)

Nodes

• Math Formula8 ×
• Column Rename5 ×
• String Manipulation5 ×
• Column Rename (Regex)4 ×
• Joiner4 ×
• Show all 19 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME JavaScript Views
• FeatureKNIME Javasnippet
• FeatureKNIME Math Expression (JEP)
• FeatureKNIME Quick Forms
• Show all 6 modules

Links

• No links available