tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
Tencent Cloud WeData
    Documentation
    Download PDF

    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.
      
      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
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy