Exclude Columns from Publishing

You can exclude columns from the publish process. This ability lets you create extra columns for deriving data that do not appear in the data output. The Datamaker UI creates excluded columns (ID and PARENT_ID) when registering certain file types (such as XML) to hold the links between the record types.
tdm10
You can exclude columns from the publish process. This ability lets you create extra columns for deriving data that do not appear in the data output. The Datamaker UI creates excluded columns (ID and PARENT_ID) when registering certain file types (such as XML) to hold the links between the record types.
The following list shows the allowed values—one for each publish type and ALL for global exclusion:
  • ALL
    Represents all publish types.
  • CSV
    Represents comma-separated variable files.
  • DB
    Represents the target database.
  • DBU
    Represents the target database updates.
  • FD
    Represents the file definition.
  • HIPAA
    Represents Health Insurance Portability and Accountability Act (HIPPA).
  • HTML
    Represents Hyper Text Markup Language (HTML).
  • JSON
    Represents JavaScript Object Notation (JSON).
  • LOC
    Represents local publish.
  • REP
    Represents repository.
  • REST
    Represents Representational State Transfer (REST).
  • SQD
    Represents SQL deletes.
  • SQL
    Represents SQL inserts.
  • SQU
    Represents SQL updates.
  • STF
    Represents source to file.
  • TXT
    Represents tab-separated text.
  • XLS
    Represents Microsoft Excel (older versions).
  • XLSX
    Represents Microsoft Excel.
  • XML 
    Represents Extensible Markup Language (XML).
You can concatenate multiple types using a colon. For example, JSON:XML excludes a column from publish to JSON or XML, but not from other publish types.
Note:
The exclusion is set in the
Maintain Table
dialog. You can access this dialog by right-clicking on a table in the left hierarchy of the
Actions for Registered Objects
dialog.