Overview
Fixed Value fields enable you to create a field and then hard-code the value for that field. This can be useful when you need a field that contains something specific further along in the data cleaning process. This article will cover how to add a Fixed Value calculated field in your data model.
Details
To add a Fixed Value field, navigate to the Transformations section of Data Management in the Cosmos Portal. Identify the table that you would like to add the fixed value field to, click the + to the right of the table name, and click "Fixed Value".
This will create a field named "Fixed Value" in the table. Click on the field to see the definition for the calculated field.
To rename the field, click the pencil icon to the right of the Name field.
You can then type in the updated name for the field and click the Save button.
In this example we have created a new field called "Type". We want to supply a fixed value of "Item" to this field. To do this, you will click the dropdown for Type and select the data type for the field. In this case, we just want to type in the text of "Item", so the Type should be set to "Text". In the Value field you can then type in Item.
When the table is processed it will have a field named "Type" and every record will have the value of Item set for this field.
Comments
0 comments
Article is closed for comments.