This section describes the actions you can take after inspecting an invalid record. You can perform these actions on individual or multiple records simultaneously. These actions generate user activity logs.
...
You can now select the specific records you wish to take action on. As you select records, you will see the available actions on the right-hand side of the toolbar.
Correcting a Record
The Correctactionallows you to update the information of an erroneous record. After correcting the records, make sure to select them for reprocessing. See 'Reprocessing a record'below for more information.
There are two ways to correct records:
...
Select the target field of the record that you want to correct. If the field is missing from the record, you can add that field using the Add Field option.
Select the type of the field.
Enter the new value.
Click Apply to correct the changes. This action cannot be undone.
Advanced Correction
You can do an advanced level of record correction by creating a desired expression with pre-defined functions or fields. The field you want to correct is updated with the output of the custom expression. Click on the Guide banner to see a brief explanation of all available functions.
...
Turn on the Use expression toggle.
Select the field you want to correct from the Target field drop-down list. If the field is missing from the list, you can add that field using the Add Field option.
Create the target value by selecting from the available fields, using pre-defined functions, or combining both. This action constructs the expression template in the Expression textbox.
Customize the template to match your specific requirements. The following table provides the list and description of the pre-defined functions provided in the Guide banner:
Mathematical Function | Description | Example |
Numeric functions | ||
Floor | Rounds down to the nearest integer or lower. |
|
Ceil | Rounds up to the nearest integer or higher. |
|
Round | Rounds to the nearest integer or decimal places. |
|
Addition | Adds two or more numbers. |
|
Subtraction | Subtracts one number from another. |
|
Division | Divides one number by another. |
|
Multiplication | Multiplies two or more numbers. |
|
String functions | ||
Uppercase | Converts a string to all uppercase letters. |
|
Lowercase | Converts a string to all lowercase letters. |
|
Trim | Removes leading and trailing spaces from a string. |
|
Concatenate | Joins multiple strings together. |
|
Slice | Extracts a portion of a string by specifying the start and end.
|
|
...
Note!
A bulk action works asynchronously, so once you submit it, it is added to the queue and processed. You must refresh the page for the updated results.
Reprocessing a Record
The Reprocess action enables you to reprocess records by sending the corrected records back to the Validate Function where they are re-validated and once successful, they are forwarded downstream. While the records are being reprocessed they are not available for correction or deletion. If the record failure is results from a result of a temporary issue or misconfigured validation, you can reprocess it without making any correctionscorrecting it.
Note!
For batch streams, the reprocessing will take place during the next stream execution, and for real-time streams, it will take place every 60 seconds.
Deleting a Record
The Delete action provides the option to remove a failed record from the system. When you click the Delete option, a confirmation prompt appears to ensure that you want to delete the selected record(s).
...