Field Settings
Introduction
Functions
In Data Factory > Field Settings, for input form fields, you can operate them for displaying, hiding, sorting, renaming, and adding calculated fields.
Application Scenarios
- For Product Management, you can adjust the order of product names and product numbers by sorting fields.
- For Student Score Management, you can calculate the total scores by adding calculated fields.
- For Employee Information Management, you can hide employee ID numbers by hiding fields to protect employee privacy.
Preview
The following figure shows how to calculate the total scores by adding calculated fields.
Setting Procedure
Where to Set
After adding the Input node, drag and drop Field Settings from the left panel to edit the data processing page. Add a connector between the Student Score and Field Settings, and you can perform operations at the Node Configuration.
Displaying/Hiding Fields
All input fields from the previous node are displayed by default.
1. Click Hide Field directly above the field. As shown in the figure below, you can hide the Math field.
2. Click Display Original Fields, you can add hidden fields.
As shown in the figure below, show the Math field.
Sorting Fields
Drag and drop fields to sort the order.
Renaming Fields
Click Rename to change the field name.
Adding Calculated Fields
Click Add Calculated Field.
The supported formulas of calculated fields include addition (+), subtraction (-), multiplication (*),
and division (/), math functions, logic functions, text functions, and date functions.
For example, add a calculated field Average Score to calculate the average grade of each student.
Note
1. When adding calculated fields, the formula compliance will also be checked, and the formula that does not meet the requirements will not be saved.
2. Do not support functions:
- Math Functions: COUNT(), COUNTIF(), LARGE(), SMALL(), SUMPRODUCT().
- Text Functions: CHAR(), RMBCAP(), UNION(), SPLIT().
- Date Function: DAYS360(), ISOWEEKNUM(), WEEKDAY().
- Advanced Functions: GETUSERNAME(), MAPX(), RECNO(), TEXTUSER(), TEXTDEPT(), UUID().
3. When adding calculated fields, you only calculate and output the data of the text type field and number type field, and you cannot output the data of the date type.
4. In the formula of Field Settings node, the supported parameter types include Single Line, Serial No., Number, Date&Time, Radio, and Single Select.
5. When you add calculated fields, the maximum nesting level in formulas cannot exceed five. For example, if you add Calculated Field A and then add Calculated Field B (B=A+1). Because A is nested into B, it will be considered as one level of nesting.
6. ISEMPTY() function only supports the determination of text fields and date fields (date fields need to be nested the TEXT() function), and does not support the determination of number fields. The formula should be "ISEMPTY(field)==TRUE() or FALSE()".
7. For the TEXT() function, the following format conversion and date format conversion in the form have the below differences:
For example, the TEXT() function in Data Factory using the two formulas can be converted to date data with keeping the original format.
TEXT(DATE(date field), "yyyyMM")
TEXT(date field, "yyyyMM")
When the TEXT() function in Data Factory converts the date function, the following parameters are different from the conversion result in the form.
