Skip to content

MPE_EXCEL_CONFIG

The MPE_EXCEL_CONFIG table configures column-level rules that are applied when uploading data via Excel. See the Excel guide for more details.

Columns

  • TX_FROM num: SCD2 open datetime
  • 🔑 XL_LIBREF char(8): SAS Libref of the target table
  • 🔑 XL_TABLE char(32): Target table name
  • 🔑 XL_COLUMN char(32): Column to which the rule applies
  • XL_RULE char(32): The rule to apply. Currently the only supported rule is FORMULA - this extracts the underlying cell formula (eg =VLOOKUP(...)) rather than the raw cell value during an Excel upload. The target column must be character, and wide enough to hold the longest formula.
  • XL_ACTIVE num: Flag indicating whether the rule is active (1 = active)
  • TX_TO num: SCD2 close datetime

Example

The following entry (from the Data Controller sample data) causes the DD_LONGDESC column of MPE_DATADICTIONARY to be loaded as a formula rather than a raw value when uploading via Excel:

insert into &lib..MPE_EXCEL_CONFIG set
    tx_from=0
    ,xl_libref="&lib"
    ,xl_table="MPE_DATADICTIONARY"
    ,xl_column="DD_LONGDESC"
    ,xl_rule="FORMULA"
    ,xl_active=1
    ,tx_to='31DEC5999:23:59:59'dt;