Loading
Business Rules Engine
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Add CSV Data to Decision Tables

            You are here:

            1. Salesforce Help
            2. Docs
            3. Business Rules Engine

            Add CSV Data to Decision Tables

            When you use CSV as the source data for your decision table, you can configure only the input and output columns for the mapping. You can upload the CSV data for your decision table only after you finish creating a decision table.

            Required Editions

            Available in: Lightning Experience
            Available in: Enterprise, Unlimited, and Developer Editions for clouds that have Business Rules Engine enabled
            User Permissions Needed
            To create, edit, and activate a decision table: Rule Engine Designer
            To run decision tables:

            Rule Engine Designer

            OR

            Rule Engine Runtime

            With a CSV-based decision table, you can maintain multiple versions of the decision table, and assign ranks to them. Also, expression sets read multiple results only from CSV-based decision tables that return multiple outputs.

            1. From the App Launcher (App explorer icon.), find and select Business Rules Engine.
            2. Click the app navigation menu, and select Lookup Tables.
            3. Select the decision table that you created by using CSV as the source.
            4. From the Table tab, click Upload CSV.
              The Add Data to Decision Table dialog box appears.
            5. Select the CSV file from your computer.
              Note
              Note The first row in your CSV file must be column names or headers.
              Note
              Note Empty cells in the CSV file are interpreted as empty strings. To represent a null value, enter NULL in uppercase. For more information, see How Null Values Work in Decision Tables.
              Warning
              Warning Due to some technical limitations with popular CSV editing tools, very large numeric values are converted into scientific notation. For example, if your file contains the value 619903629728, it's converted to 6.19904E+11 when the file is saved. When the file is then imported into Business Rules Engine, it causes formatting issues, resulting in failed lookups. To avoid this, follow safe editing best practices as outlined here.
              • Configure your CSV editor to treat numbers as text.
              • If your editor has a setting to disable scientific notation conversion for very large numbers, use the setting.
              • Consider using a specialized editor such as EmEditor, which is designed for avoiding such issues. This is especially useful for large edits.
              • For minor edits, consider using simple apps such as Notepad, which saves your content as text.
            6. To add the data from the CSV file to your decision table, click Add Data.
              To view the data rows in your decision table, refresh the page. You can verify the status of the CSV upload by checking the CSV Upload Status field in the Table tab.
              Note
              Note Only Salesforce admins and users with the Rule Engine Designer permission set who own the associated decision matrix can edit the decision table. Users with general Read/Write access can't make edits unless they are the owner.
             
            Loading
            Salesforce Help | Article