Contents Now Platform Administration Previous Topic Next Topic Create a transform map Subscribe Log in to subscribe to topics and get notified when content changes. ... SAVE AS PDF Selected Topic Topic & Subtopics All Topics in Contents Share Create a transform map Every import operation to a production table requires at least one transform map associated with an import set. Before you beginRole required: import_transformer, import_admin, or admin About this taskThe transform map specifies the data relationships between the import set and the target table. For every transformation, you must either create a new transform map or select an existing one. Procedure Navigate to System Import Sets > Create Transform Map. Complete the form. Table 1. Table transform map fields Field Description Name User-friendly label to identify the transform map. Source table Import table containing the raw import set data. An import table is any table that extends the Import Set Row [sys_import_set_row] table. You can select only tables within the currently selected application scope. Active Check box to make the transform map available for use. Run business rules Check box to run business rules, workflows, approval engines, auditing, and field normalization while the transformation inserts or updates data into the target table. Clearing this check box runs GlideRecord.setWorkflow() with a value of false. Enforce mandatory fields Selects whether to enforce mandatory fields on the target table: No: Do not enforce mandatory fields. Only Mapped Fields: Enforce mandatory mapped fields only. All Fields: Enforce all mandatory fields. Copy empty fields Check box to copy empty field values and override existing target field values. Create new record on empty coalesce fields Check box to create a new record when all coalesce fields are empty, instead of ignoring the record or overwriting an existing record.If Coalesce empty fields is selected for any field in the record, the record is coalesced. Application Application scope: global or per application. Created Transform map creation date (populated automatically). Target table The table in which you want the transformed data to be inserted. You can select only tables within the currently selected application scope or the global scope, or tables that grant write access to other applications. Order Order in which to apply transform maps if more than one map fits the conditions. The system runs transform maps from lowest to highest Order. Run script Check box to define a script that transforms field values in the source table to the target table. Script Transform map script that transforms field values in the source table to the target table. The system runs the transform map script in addition to any field maps. Important: The string NULL is a reserved word. It should not be used as a field value in import set transform maps or anywhere in the First name or Last name fields. The reserved word is NULL in all capital letters. A field with the value Null or null, for example, is acceptable. NULL should be used only to clear out a particular field. On this page Send Feedback Previous Topic Next Topic
Create a transform map Every import operation to a production table requires at least one transform map associated with an import set. Before you beginRole required: import_transformer, import_admin, or admin About this taskThe transform map specifies the data relationships between the import set and the target table. For every transformation, you must either create a new transform map or select an existing one. Procedure Navigate to System Import Sets > Create Transform Map. Complete the form. Table 1. Table transform map fields Field Description Name User-friendly label to identify the transform map. Source table Import table containing the raw import set data. An import table is any table that extends the Import Set Row [sys_import_set_row] table. You can select only tables within the currently selected application scope. Active Check box to make the transform map available for use. Run business rules Check box to run business rules, workflows, approval engines, auditing, and field normalization while the transformation inserts or updates data into the target table. Clearing this check box runs GlideRecord.setWorkflow() with a value of false. Enforce mandatory fields Selects whether to enforce mandatory fields on the target table: No: Do not enforce mandatory fields. Only Mapped Fields: Enforce mandatory mapped fields only. All Fields: Enforce all mandatory fields. Copy empty fields Check box to copy empty field values and override existing target field values. Create new record on empty coalesce fields Check box to create a new record when all coalesce fields are empty, instead of ignoring the record or overwriting an existing record.If Coalesce empty fields is selected for any field in the record, the record is coalesced. Application Application scope: global or per application. Created Transform map creation date (populated automatically). Target table The table in which you want the transformed data to be inserted. You can select only tables within the currently selected application scope or the global scope, or tables that grant write access to other applications. Order Order in which to apply transform maps if more than one map fits the conditions. The system runs transform maps from lowest to highest Order. Run script Check box to define a script that transforms field values in the source table to the target table. Script Transform map script that transforms field values in the source table to the target table. The system runs the transform map script in addition to any field maps. Important: The string NULL is a reserved word. It should not be used as a field value in import set transform maps or anywhere in the First name or Last name fields. The reserved word is NULL in all capital letters. A field with the value Null or null, for example, is acceptable. NULL should be used only to clear out a particular field.
Create a transform map Every import operation to a production table requires at least one transform map associated with an import set. Before you beginRole required: import_transformer, import_admin, or admin About this taskThe transform map specifies the data relationships between the import set and the target table. For every transformation, you must either create a new transform map or select an existing one. Procedure Navigate to System Import Sets > Create Transform Map. Complete the form. Table 1. Table transform map fields Field Description Name User-friendly label to identify the transform map. Source table Import table containing the raw import set data. An import table is any table that extends the Import Set Row [sys_import_set_row] table. You can select only tables within the currently selected application scope. Active Check box to make the transform map available for use. Run business rules Check box to run business rules, workflows, approval engines, auditing, and field normalization while the transformation inserts or updates data into the target table. Clearing this check box runs GlideRecord.setWorkflow() with a value of false. Enforce mandatory fields Selects whether to enforce mandatory fields on the target table: No: Do not enforce mandatory fields. Only Mapped Fields: Enforce mandatory mapped fields only. All Fields: Enforce all mandatory fields. Copy empty fields Check box to copy empty field values and override existing target field values. Create new record on empty coalesce fields Check box to create a new record when all coalesce fields are empty, instead of ignoring the record or overwriting an existing record.If Coalesce empty fields is selected for any field in the record, the record is coalesced. Application Application scope: global or per application. Created Transform map creation date (populated automatically). Target table The table in which you want the transformed data to be inserted. You can select only tables within the currently selected application scope or the global scope, or tables that grant write access to other applications. Order Order in which to apply transform maps if more than one map fits the conditions. The system runs transform maps from lowest to highest Order. Run script Check box to define a script that transforms field values in the source table to the target table. Script Transform map script that transforms field values in the source table to the target table. The system runs the transform map script in addition to any field maps. Important: The string NULL is a reserved word. It should not be used as a field value in import set transform maps or anywhere in the First name or Last name fields. The reserved word is NULL in all capital letters. A field with the value Null or null, for example, is acceptable. NULL should be used only to clear out a particular field.
