NIM

Split a table

Use the Add Split Table feature to transform a character-separated column into a standalone table with a separate row per character-separated value.

  1. Expand a system's table list.

  2. Locate the table that has the character-separated column that you want to split. For example:

    2021-08-06_11-43-15.png
  3. Ensure that the table has been assigned a key. This must be a different column than the one you're splitting. See Assign primary keys to tables.

    For this example, the sourceID column has been assigned as the key.

  4. Go to Systems > Overview.

  5. Click configure_tables.pngConfigure for the system.

  6. Go to the Tables tab.

  7. Click Add Split Table.

  8. Enter a Result Table Name and a Separator.

  9. In the Based On Table dropdown, select the table that contains the column to be split.

  10. In the Based On Column dropdown, select the column to be split.

    2021-08-06_12-01-12.png
  11. Click Save.

  12. The new split table is added to the system.

    2021-08-06_12-04-00.png