Block Properties Fields Tab

When configuring Block Properties on a Block in a Map, the Fields tab shows the source and target fields. The source side displays the fields from the entity selected in the Query Block, operation results from prior Blocks, and fields from child entities if the Query Block includes Hierarchical data. The target side displays the fields from the Entity selected in the Block Properties General tab for this Block. When working with Hierarchical Data you may see additional fields.

Use the Fields tab to:

Note: When you first open the Fields tab, the icon displays and the Errors/ Warnings tab indicates that there are Errors. This is expected behavior. Errors and warnings display for the Fields tab until all required data is entered. See Block And Map Errors And Warnings.

Fields Tab

Icons And Fonts

On the Fields tab, some fields contain either icons or different fonts to help you determine important fields.

Icon Definition

Source Pane

Select fields — Selects all fields for an entity in the Source Pane. Click the Deselect All link to clear selected fields for all entities.

Clear Selected fields — When all fields for an entity are selected, this icon clears the selections for that entity in the Source Pane. Click the Deselect All link to clear selected fields for all entities.

Primary key — One or more fields that uniquely identify each record in the source Entity.

Target Pane

Select fields — Selects all fields for an entity in the Target Pane. Click the Deselect All link to clear selected fields for all entities.

Clear Selected fields — When all fields for an entity are selected, this icon clears the selections for that entity in the Target Pane. Click the Deselect All link to clear selected fields for all entities.

Primary key — One or more fields that uniquely identify each record in the target Entity.

Bold Text

Required field — Fields that display in bold must have links. A warning displays until you create a link for this field.

Italics Text

Read-only field — Fields that display in italics should not be used with any formula or link that attempts to write to the field. However, you can use read-only source fields as a reference in formulas. A warning displays if you create a link on a read-only field.

Link error — An error exists that causes this Map to be incomplete. When the Solution runs, TIBCO Scribe® Online skips this Map.

Link warning — An error exists that may cause errors when the Map runs.

Formula Icon — Opens the Formula Editor.

Target Pane - Conditional Field Mapping

Skip Null Icon — Enables the Skip Null option for the field. If the field mapping results in a NULL value, the NULL is not written to the target field.

Skip Null Enabled Icon — Indicates that the Skip Null option is enabled for this field.

IsFieldSet Icon — Enables the ISFIELDSET function for this field.

In some cases, when a Connector encounters a source field that has no value, it does not send the field at all. For example, if an address record were missing City, the Connector would send Street, State, Zipcode but would leave City out of the data set sent to the Map.

Default behavior when a field is completely missing from the source and IsFieldSet is not enabled, is to write a NULL to the target database for that field.

When IsFieldSet is enabled, if the field name is not included in the results from the source, nothing is written to the target for this field. If the field name is returned but has no associated value, it is written to the target as a blank or NULL.

Note: This option can only be enabled for fields that are mapped with a field name. If the field contains a formula, this option cannot be selected. If a formula is entered after the option is set, a warning is displayed on the Errors and Warnings tab.

IsFieldSet Enabled Icon — Indicates that the IsFieldSet option is enabled for this field.

Functional Condition Icon — Enables the Functional Condition option for this field and opens the Mapping Condition Editor where you can enter the associated formula. The formula must resolve to a boolean. If the formula resolves to true, the source value is written to the target. If the formula resolves to false, the source value is not written to the target. For example, if you enter the following:

 

IF(Source.City="Boston","False","True")

 

Using this formula, if the value of Source.City is Boston, the formula returns False and nothing is written to the target. If the value of the Source.City field is anything else, the formula returns True and the value of Source.City is written to the target. In this scenario, all cities except Boston would be written to the target.

 

If you enter the following:

 

IF(Source.City="Boston","True","False")

 

Using this formula, if the value of Source.City is Boston, the formula returns True and Boston is written to the target. If the value of the Source.City field is anything else, the formula returns False and the value of Source.City is not written to the target. In this scenario, only Boston would ever be written to the target.

Note: The Mapping Condition dialog is very similar to the Formula Editor dialog. Make sure the title of the dialog says Mapping Condition. For information on using the fields on this dialog, see Formula Editor.

Functional Condition Enabled Icon — Indicates that the Functional Condition option is enabled for this field.

Clear Condition Icon — Indicates that the Functional Condition option is enabled for this field. Clears any conditional settings on the selected fields including:

  Skip Null

  IsFieldSet

  Functional Condition

See Conditional Field Mapping for additional information.

Target Pane Toolbar

The Target pane toolbar contains the following options to help you easily manage links and formulas.

Creating Data Links

When you create a data link between a source and target field, TIBCO Scribe® Online integrates the data from that source to the target field when the Solution runs.

Tip: When you create links between fields of different data types, TIBCO Scribe® Online tries to automatically convert the source data type. See Data Conversion and Mapping Custom Data Types for more information.

When you are working with hierarchical data, source parent and child entities are available for mapping as long as there is a one-to-one relationship. If there is a one-to-many relationship or a collection, such as a Contact with several Addresses, you must use a For Each Child Block and an Add Block to access and write the children. See Hierarchical Data and Mapping Hierarchical Data Fields.

  1. Select the Source Entity Fields you want to link.
  2. Drag the source field to the target field.
  3. Unless there is a Data Type Mismatch or other problem, the source and target fields are now linked.
  4. The linked Source field, with its entity name, displays in the Formula column of the Target pane.

When you run your Solution, TIBCO Scribe® Online performs the requested operation on this data.

Note: When you first open the Fields tab, the Matching Criteria tab, or the Lookup Criteria tab TIBCO displays an error. To correct the error, create a match field.

Note: Field or entity names that contain special characters may display in TIBCO Scribe® Online differently than in the original data. A special character is any character other than A-Z, a-z, 0-9, or underscore. If you use these fields or entities in Maps or in formulas, you need to use the names as they appear in TIBCO Scribe® Online.

Formula Editor

Transform your data as it is integrated into the target by using the functions, operators, and constants in the Formula Editor. You can type a simple formula in the target field or use the Formula Editor for more complex formulas.

To open the Formula Editor, select a field and then select the Formula Editor icon . For details about creating and editing formulas, see Formula Editor.

Note: As you create data links and formulas in the Fields tab, TIBCO Scribe® Online validates your formula and may cause the error () or warning () icon to appear in the Formulas column as you enter information. You can ignore these as you are typing; when the formula is done, select the Validate button, and they should disappear. If they do not, check the Block And Map Errors And Warnings for information.

Viewing Field Properties

To access additional field information, select the Info icon for that field. Details displayed vary depending on the type of field selected but may include any of the following information.

Field Definition

Allow Nulls

Displays Yes or No to indicate whether or not NULL values are accepted.

Primary Key

Displays Yes or No to indicate whether or not the field is a Primary Key in the Source or Target datastore. Uniquely identifies the record in the datastore.

Description

Displays the native data type with any additional information available through the metadata, such as acceptable values for picklists, or if the field is an Id lookup field. Data types include:

  Boolean

  Currency

  Date

  Double

  Email

  Id

  Int

  Phone

  Picklist

  Reference

  String

  Textarea

  URL

Original Name

Displays the original name of a field when the field name shown in TIBCO Scribe® Online is different than the original field name from the datastore.

Troubleshooting Field Links

If TIBCO Scribe® Online finds target fields that do not process correctly when the Solution runs:

Note: When you first open the Fields tab, you may see errors or warnings. In general, these are for fields for which links are required.

Correcting Errors And Warnings

If there are other errors or warnings, see the Block And Map Errors And Warnings for information.

Related Topics

Working With Blocks

Autolinking

Conditional Field Mapping

Mapping Hierarchical Data Fields

Block Properties General Tab

Block And Map Errors And Warnings

Mapping Custom Data Types