Guide to Concatenating Data from Two Columns in a JSON Table

Introduction

In Table Editor, you can concatenate data from any two columns when using JSON as a data source. This works similarly to using formulas in Excel to merge two cells.

For example, if you have 8 fields from A to H, you can merge data from columns A and B to create a new column displaying the concatenated values.

Steps to Implement

Step 1: Select the Column for Displaying the Result

  1. Open Table Editor and select the JSON data table.
  2. Choose the column where you want to display the concatenated data.
  3. Click “Style” in that column’s settings.

Step 2: Add Code in the “Renderer” Field

  1. In the column settings, find the “Renderer” field.
  2. Insert the following code: row[0] + ' ' + row[1];

Explanation of the Code

  • row[0] retrieves the value from column A (the first field in the JSON structure).
  • row[1] retrieves the value from column B (the second field in the JSON structure).
  • ' ' adds a space between the concatenated values.

    Step 3: Save Changes

    1. Click “Save” to apply the configuration.
    2. Check the table to ensure that the values from columns A and B are concatenated correctly.