Problem definition

By default, when importing objects and concatenating values from multiple datalocators, the default concatenator is space. However, it is not possible to ignore the concatenator and not use any value (e.g. so that "ABC" and "1234" together become "ABC1234").

Suggested resolution

Add option to disable concatenator completely, so the values are concatenated without any character in between.

Workaround

• Create the desired value right on the source side, example:
  • If using database as a source, create a new column that contains concatenated values from other desired column values (without space), then use that new column as a datalocator.
  • If using CSV as a source, open the file in Excel (or other spreadsheet editor) and use CONCATENATE function to generate a desired value in a new column, then use that generated column as a datalocator.
• Use Insight Automation rule, that would execute a Groovy script which would find if there is a space in the object attribute and remove it.
  • Community blog that provides an example Groovy script: Groovy script to remove default concatenator after importing Insight objects