What are Custom Fields?
Custom Fields provide more flexibility in meeting your data requirements by serving as a tool for data cleaning, manipulation, and calculations. This feature allows users to add a new, customizable, field to your raw data stream at the record level and save it for later use. Users can utilize a number of standard SQL functions to build new fields entirely in-platform.
Who can use Custom Fields?
This feature is available for all admin and power users.
When should I use Custom Fields?
You can use Custom Fields whenever you need to add new fields to your data set. Here’s a few use cases that can be addressed with Custom Fields:
-
Adding internal custom metrics at a document-level to leverage raw source data
-
Example: Custom “Proprietary Impact Score”
-
-
Adding custom grouping (without needing bins)
-
Example: Converting a “group_id” of numbers to the name of the group
-
If group_id==12039130 then ‘Marketing’ else ‘Other'
-
-
Cleaning up number formatting
-
Example: cleaning up null values by setting as 0
-
-
Create a word count of your unstructured data fields
-
Converting categorical data to numerical data
How do I use Custom Fields?
-
From your Stratifyd Workspace, navigate to the Settings Tab and select the data stream in which you’d like to add a new field.
-
Select the Data Fields tab.
-
Click the Add Field button.
-
Add an expression and rename the field.
TIP: See a full list of supported functions below.
-
Validate and check your sample results
-
Click the Submit button to save the field to your data stream
This custom field is now available in your data stream.
What functions are supported?
STRING FUNCTIONS |
NUMBER FUNCTIONS |
DATE FUNCTIONS |
LOGICAL FUNCTIONS |
CONTAINS |
ABS |
DATEADD |
CASE |
ENDSWITH |
CEILING |
DATEDIFF |
END |
FIND |
DIVIDE |
DATENAME |
IF |
FINDNTH |
EXP |
DATEPART |
IFNULL |
LEFT |
FLOOR |
DATETRUNC |
IIF |
LEN |
MIN |
DAY |
ISDATE |
LOWER |
POWER |
ISDATE |
ISNULL |
LTRIM |
ROUND |
MAKEDATE |
|
MAX |
SIGN |
MAKEDATETIME |
|
MID |
SQRT |
MAKETIME |
|
MIN |
SQUARE |
MONTH |
|
REPLACE |
|
NOW |
|
RIGHT |
|
TODAY |
|
RTRIM |
|
YEAR |
|
SPACE |
|
HOUR |
|
SPLIT |
|
|
|
TRIM |
|
|
|
UPPER |
|
|
|
WORDCOUNT |
|
|
|
Editing Fields in a Data Stream
You may wish to control which data fields are included in your analysis. There is a limit of 300 data fields per stream, so if you are leveraging multiple sources in a single stream you may need to review which should be included. Here's how to do so:
-
From your Stratifyd Workspace, navigate to the Settings Tab and select the data stream in which you’d like to edit fields.
-
Select the Data Fields tab.
-
Click Edit Fields.
-
Use the check boxes to manually select or deselect individual fields you'd like to add or remove. Use the box at the top to select to deselect all fields at once. You can also add an alias for a field, or change the field type (if available).
-
Once you've selected the fields you'd like to include in your analysis, click Reprocess Stream.
Further questions?
We're here to help! Don't hesitate to contact us for further assistance via chat or submit a ticket!
Comments
0 comments
Please sign in to leave a comment.