Add column node

Sometimes data you work on are incomplete. To supplement the file with the required data, you can use the Add column node. It lets you create a new column with the rows that containadd the target value in a file.

Node configuration


  1. In the Add column field, enter the unique column name.
  2. Select one of the options:
    • Custom value - when you select this option, the rows in the new column are filled with the value you define.
      Important: If you leave an empty field for the “Custom value” option, the values in the column will be empty strings.
    • No value - when you select this option, the new column is added with empty rows.
      Important: If you choose the “No value” option, the values in the column will be null. It means that if a corresponding attribute exists in the database, it will be deleted.
    • UUID - fills the column with a generated UUID v4 (unique for each row).
    • Current date - fills the column with the current date (the date and time are generated on an ongoing basis during the transformation).
  3. Confirm by clicking Apply.
  4. Before you save the settings, you can check the preview of the file after changes in the Output data tab.
  5. To add more columns, add subsequent Add column nodes. You can add one column in each Add column node.

Current date option

Using the Current date option, you can enrich your data with a dynamically injected date and time which can be used, for example, to build an event salt. To define a rule with Current date:

  1. Select a timezone.
  2. Select one of the available formats:
    • ISO (for example 2022-10-05T05:55:16.786596Z)
    • Timestamp (for example 1664949342323)
    • MMM d, YYYY (for example Oct 5, 2022)
    • MMM d, YYYY, HH:mm:ss (for example Oct 5, 2022, 05:57:14)
    • YYYY-MM-dd HH:mm (for example 2022-10-05 05:57)
    • Custom - you can create your own date and time format.

Custom date format

You can use the following elements to build a custom format. The example values use October 05, 2022 as the date.

  • MMM - name of month (Oct)
  • MM - number of month (10)
  • DD - day of year (278)
  • dd - day of month (05)
  • YYYY - year (2022)
  • YY - year (22)

Example of use


You can create a transformation of a sample file with customers’ data by adding a marketing_agreement column with the true value. Later, you can use this transformation while importing customers to Synerise.

Transformation of a sample file with customer's data
Transformation of a sample file with customer's data
  1. Start the transformation with the Data Input node.
  2. Click the node.
  3. In the configuration of the node, upload a sample file with customer data.
  4. Add the Add column node and join it with the Data Input.
  5. In the configuration of the Add column node:
    1. In the Add column field, enter marketing_agreement.
    2. Leave the Defined option selected.
    3. Next to the Defined option, in the field, enter true.
    Configuration of the Add column node
    Configuration of the Add column node
  6. Confirm by clicking Apply.
  7. Add the Output data node and join it with the Add column node.
😕

We are sorry to hear that

Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.

😉

Awesome!

Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.

Close modal icon Placeholder alt for modal to satisfy link checker