Content Comparison

You create a calculated field for the Domain by writing an expression that computes a value based on the data in another column or columns. In order for the value to be coherent, all columns that appear in the expression for a calculated field must be from the same join tree. 

...

1. Span
   style color: #000000;
   In the Field Name field, enter a short name for the calculated field.

   
   
   

   • Span
     style color: #000000;
     This name becomes the ID of the field in the Domain. After, you can give the field a more meaningful label and full description.

     
     
     

2. Span
   style color: #000000;
   In the Type field, select a datatype for the calculated field.

   
   
   

   • Span
     style color: #000000;
     The expression you write must return a value of this type. Generally, this datatype matches the datatype of the columns in the expression—it is helpful to be familiar with the datatypes of columns in the data source.

     
     
     

3. Span
   style color: #000000;
   In the Expression field, enter an expression to compute the value of the calculated field.

   
   
   

   • Span
     style color: #000000;
     You write expressions in the Domain Expression Language

     
     
     

   • Span
     style color: #000000;
     To insert a reference to the value of another column, expand the join-tree to find its table and double-click the column name. The column name appears in the expression at the cursor, qualified by its table name. You can also double-click a calculated field name to insert a reference to it in any expression.

     
     
     

     Tip
     icon false
     Do not insert a column reference form from unjoined trees. The Domain Designer does not validate expressions as they are written, and the unjoined trees will not be valuable.

     
     
     

4. Span
   style color: #000000;
   Click the Save Field button to save the new calculated field. To clear the calculated field editor without saving, click the Cancel button.

   
   
   

...

1. Span
   style color: #000000;
   Cancel any input in the Calculated Field Editor.

   
   
   

2. Span
   style color: #000000;
   In the Available Fields panel, double-click the name of the field you wish to edit.

   
   
   

3. Span
   style color: #000000;
   Modify the contents of the Field Name, Type, or Expression fields.

   
   
   

4. Span
   style color: #000000;
   Click the Save Field button to save the new definitions. To delete the calculated field from the Domain, click the Delete Field button. To cancel any changes, click the Cancel button.

   
   
   

...

...