Important Nexla Help Center Update:
Nexla's Zendesk Help Center pages are being deprecated and will soon no longer be available.
Nexla Documentation is now the home for Nexla's User Guides, with improved formatting and categories that are easier to navigate, providing a better overall user experience.
Please update any bookmarks to the new Nexla Documentation site (docs.nexla.com/user-guides).
_______________________________________________
This article provides information about setting default attribute values in Nexla.
Contents:
1. Default Value Uses
2. Setting Default Values in the Nexset Designer
3. Setting Default Values During Lookup Creation
1. Default Value Uses
Sometimes, an expected value is not present in a lookup or transformation. Default values can be used to tell Nexla how to note these missing values in an output Nexset; otherwise, no record will be written for any missing attribute values. Default values can be set as Null or as a custom string or number.
Default values can be useful, for example, when missing records can cause errors in downstream data processes or when missing values need to be noted and called out with an alert.
2. Setting Default Values in the Nexset Designer
- To set a default value when constructing a transform in the Nexset Designer, click
in the Nexset Rules panel, and select
. This will create a new Default Values rule group.
Default values can only be set for attributes included in the output Nexset according to previously added Nexset Rules.
- Use the left pulldown menu to select the output attribute for which a default value should be set.
- Select the type of default value that should be set from the right pulldown menu.
To set a string-type default value, select "String" and enter the desired default string in the text field to the right.
To set a numeric default value, select "Number", and enter the desired default numeric value in the text field to the right. - Click
to apply the current Nexset rules and preview the output Nexset content in the Nexset Output panel.
To preview default value rule outputs when no absent records are contained in the input samples, see the article Edit Input Samples to learn how to temporarily modify incoming samples.
- Click
in the top right corner of the screen to save the current transform construction progress. Once transform construction is complete, click
to save the transform and close the Nexset Designer.
3. Setting Default Values During Lookup Creation
- Default values for key columns can also be set when creating a static or dynamic lookup. Instructions can be found in the below documents.
Static Lookups
To set a default value when creating a lookup by entering text in a table, see Section 2, Step 7.
To set a default value when creating a lookup by entering raw text, see Section 3, Step 6.
To set a default value when creating a lookup from a local file, see Section 4, Step 5.
Dynamic Lookups
To set a default value when creating a dynamic lookup, see Section 3, Step 4.
Comments
0 comments
Please sign in to leave a comment.