Feature Table To List

Input Ports

Input Feature Table: The input set of Features that define each Product in the format of a wide table. The Input Feature Table should include the following columns:

1. Product (string): The name of each Product in the Market. Products found in each row of the Input Feature Table are typically unique, with the list of Features associated with each Product listed in the same row. But the uniqueness of Product names is not checked, and duplicate rows will also be appended to the Output Feature List. Rows with missing Product names will be skipped. If the 'Product' column is missing then the 'RowID' will be used instead.
2. List of Feature Columns (string): (optional) All of the other columns in the Input Feature Table can correspond to the different Features associated with each Product. It would be most common for all of these Feature columns to be of type 'String' but other types are also allowed to provide the user with greater flexibility. The user-selected Feature columns will be saved in the 'Feature' column in the Output Feature List. The heading names of the user-selected columns will also be saved in the 'Attribute' column in the Output Feature List. Column cells with missing Features will be skipped.
3. Price (double): (optional) The Price of the Product. This Price will be converted into a String value just like the other List of Features and included in the Output Feature List. But the Product Generator node will recognize the Price Feature as being special, and will use it to set the Price in the Output Product Array.
4. Cost (double): (optional) The Cost of the Product. This Cost will be converted into a String value just like the other List of Features and included in the Output Feature List. But the Product Generator node will recognize the Cost Feature as being special, and will use it to set the Cost in the Output Product Array.
5. Quantity (integer): (optional) A reference Quantity sold for the Product in the actual (real-world) Market. This Quantity will be converted into a String value and, like Price and Cost, will be recognized by the Product Generator node as being a special Feature. If the Quantity is provided in a downstream Market Simulation node then a 'Quantity Error' can be calculated as part of the results in the Output Product Array.

Output Ports

Output Feature List: The equivalent set of Features listed as Product-Feature pairs. The Output Feature List will contain these columns:

1. Product: The Product names found in the Input Feature Table.
2. Attribute: The column headers from the Input Feature Table for the Features that were selected by the user for inclusion. These column headers typically describe the high-level Attribute type for the Features found within each the Product. For example, for ice cream Products, the Attributes may include: Flavor, Color, Packaging, Size, and Toppings.
3. Feature: The list of Features associated with each Product found within the user-selected columns in the Input Feature Table.

Popular Predecessors

• Column Filter26 %
• Excel Reader14 %
• Table Manipulator14 %
• Decision Tree Predictor11 %
• Split Collection Column9 %
• Show all 11 recommendations

Popular Successors

• GroupBy24 %
• Joiner19 %
• Column Rename14 %
• Edit Attributes10 %
• Product Generator5 %
• Show all 11 recommendations