Chapter 45. Uploading spreadsheet decision tables to Business Central


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 Menu Design Projects and click the project name.
  2. Click Add Asset Decision Table (Spreadsheet).
  3. Enter an informative Decision Table name and select the appropriate Package.
  4. 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 44, Defining spreadsheet decision tables.

    You can upload a new version of the decision table or download the current version:

    Figure 45.1. Uploaded decision table options

    Decision table example
Red Hat logoGithubRedditYoutubeTwitter

Learn

Try, buy, & sell

Communities

About Red Hat Documentation

We help Red Hat users innovate and achieve their goals with our products and services with content they can trust.

Making open source more inclusive

Red Hat is committed to replacing problematic language in our code, documentation, and web properties. For more details, see the Red Hat Blog.

About Red Hat

We deliver hardened solutions that make it easier for enterprises to work across platforms and environments, from the core datacenter to the network edge.

© 2024 Red Hat, Inc.