tencent cloud

All product documents
Tencent Cloud WeData
DocumentationTencent Cloud WeDataOperation GuideData IntegrationOffline Synchronization Task Configuration and Operation and MaintenanceConversion Node Configuration
Conversion Node Configuration
Download PDF
Last updated: 2024-11-01 17:33:23
Conversion Node Configuration
Last updated: 2024-11-01 17:33:23
Download PDF
Offline synchronization supports three types of data nodes: input, output, and transformation.

String Replacement

The string replacement node mainly uses Java regular expressions to match and replace the content of string fields. This node will perform the replacement operation when the string is partially or completely matched in the field content. The configuration parameters for conversion rules are as follows:
Parameter
Description
Field
Select the field to match the string. The fields processed by this node must be of string type.
Note:
In this conversion node, multiple conversion rules can be configured for the same field. Multiple rules will be serialized according to the configuration order.
Regular expression
Java regular expression used to match the original field content.
New string
Replace the matched field content with the specified new string.
Replacement method
Supports replacing only the first match or all matches.
Delete
Delete this row rule.

Time format conversion

The time format conversion node is mainly used to convert the time field in the table to the target format, such as converting yyyymmdd time format to yyyymmdd hh:mm:ss format. The conversion rule parameters are as follows:
Parameter
Description
Field
Select the field that needs to match the time format. The field should be of types such as datetime, time, timestamp, date, etc.
Note:
In this conversion node, multiple conversion rules can be configured for the same field.
Source time format
Specify the time format for this field. If the specified format does not match the actual format, the conversion will not be performed, and the data will be processed as dirty data.
Target time format
For each record, if the current field matches the specified source target format, the system will convert the source time format to the target format.
Delete
Delete this row rule.
Note
Currently, this node only supports offline synchronization tasks.

Value Conversion

The value conversion node is mainly used for standardized processing of field content. This node will perform a replacement operation when the field content is exactly equal to the specified content. After the replacement, the original field content will be updated. For example, "CHINA" will be uniformly replaced with "CHN". The conversion rule parameters are as follows:
Parameter
Description
Field
Select the field that needs time format matching. Fields are by default sourced from upstream fields, and all upstream fields are supported.
Note:
In this conversion node, multiple conversion rules can be configured for the same field.
Matching Value
Used to determine if the original field is equal to the specified value. If equal, the replacement behavior will replace the value.
Replacement Value
Value conversion target, cannot be empty.
Delete
Delete this row rule.
Note
Currently, this node only supports offline synchronization tasks.

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon