Columnar Table Node

The Columnar Table Node allows complex decisions with multiple inputs and outputs to be created easily. Essentially, it is a visual interface that can hold many if-then-else statements in one place to evaluate rules and make decisions. 

Recommended places to use this node:

The columnar table is commonly used across processes that are used to filter records through exclusion logic or decide what kind of content a person is going to receive in a tweet, email, or personalized web experience. As the columnar table is a generic piece of logic, it has a wide range of uses and applications.

General Usage:

• In the columnar table, each column is called a 'decision', each row is called a 'rule' (i.e. - input), and each row after the 'results' row is called a 'result' (i.e. - output).
• Columnar tables are particularly good for circumstances where you may have a large number of input fields, but the combination of decisions is quite sparse compared to the number of combinations. It is good practice to have a catch-all rule where all rules are blank (and hence true) to ensure that a result is always generated.
• All decisions are evaluated from left to right, and the rules in a decision are evaluated from top to bottom.
• A blank rule will accept any input and will always return true.
• Each decision, if evaluated to be true, can be used to set multiple output results.
• The first rule where all rules are true is the decision; any decision placed after will not be evaluated. Hence, it is always best to have your strictest decisions on the left.

Adding a Columnar Table

Step 1: Click Create and choose the Columnar Table in the 'Logic' section.

Step 2: The columnar table starts blank, as below. To add new decisions, click Add Decision. This will prompt for the decision column name, which is shown at the top of the table. 

Image Caption

Starting screen for Columnar TablesAfter assigning a name to the decision, the name will appear in the first empty column on the right.

Step 3: After adding a decision, to add a new rule that needs to be evaluated, click on the + icon next to Rules.
Step 4: After a decision and a rule have been made, select the white open space between the rule and decision to put in the evaluation logic.

The criteria for the decision and the rule intersection is a JavaScript expression entered into the Edit Rule panel on the right-hand side of the page.

Using the 'Basic' window to add a rule that evaluates whether or not the customer has opted-in to receive email communication

Step 5: After a decision, a rule, and the evaluation logic have been created, add the results to generate the desired outputs if a decision evaluates to true.

• Click on the plus icon + next to the Results label to add the results to the decision table.

The value for the Result for a particular column can be a literal value, a schema location, or a public variable. The Result Value is set via the panel on the right-hand side of the screen.

• Click in the result box for that decision to show the current value in the Edit Result Value and Schema, Literal, or Public Variable chooser.

Step 6: For each characteristic created, a data source must be added to the list of parameters outside of the node at the graph level.

Validation Warnings

: All the invalid notifications will be displayed after expanding the Invalid Drop-down.

Errors

• ColumnarTable is unable to find value for a rule with this data source - this means that the incoming data did not contain the expected value in the schema or public variable

See Also: 

• Troubleshooting and Debugging
• Business Logic Nodes
• Columnar Table Node
• Decision Tree Node
• 2D Table Node
• Conditional Node