Chapter 6. Uploading spreadsheet decision tables

After you define your rules in an external XLS or XLSX spreadsheet of decision tables, you can upload the spreadsheet file to your project in Business Central.

Important

You should typically upload only one spreadsheet of decision tables, containing all necessary RuleTable definitions, per rule package in Business Central. You can upload separate decision table spreadsheets for separate packages, but uploading multiple spreadsheets in the same package can cause compilation errors from conflicting RuleSet or RuleTable attributes and is therefore not recommended.

Procedure

  1. In Business Central, go to MenuDesignProjects and click the project name.
  2. Click Add AssetDecision Table (Spreadsheet).
  3. Enter an informative Decision Table name and select the appropriate Package.
  4. Select the file type (xls or xlsx), click the Choose File icon, and select the spreadsheet. Click Ok to upload.
  5. In the decision tables designer, click Validate in the upper-right toolbar to validate the table. If the table validation fails, open the XLS or XLSX file and address any syntax errors. For syntax help, see Chapter 5, Defining spreadsheet decision tables.
Converting a spreadsheet decision table to a guided decision table

To convert a spreadsheet decision table to a guided decision table, click Convert in the upper-right toolbar in the decision tables designer. Converting the spreadsheet to a guided decision table enables you to edit the table data directly in Business Central. For more information about guided decision tables, see Designing a decision service using guided decision tables.