Skip to main content

Join

Joins an array of strings into a single string with a separator between elements.

Common Properties​

  • Name - The custom name of the node.
  • Color - The custom color of the node.
  • Delay Before (sec) - Waits in seconds before executing the node.
  • Delay After (sec) - Waits in seconds after executing node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.
info

If the ContinueOnError property is true, no error is caught when the project is executed, even if a Catch node is used.

Inputs​

  • Elements - An array of strings to join together.
  • Custom Elements - Additional individual string elements to include (optional, can add multiple).
  • Separator - The delimiter to place between elements.

Options​

This node does not have configurable options.

Output​

  • Result - A single string with all elements joined by the separator.

How It Works​

The Join node combines an array of strings into one string:

  1. Takes all elements from the Elements array
  2. Adds any Custom Elements specified
  3. Joins them with the Separator between each element
  4. Returns the combined string
  • Empty separator - elements are concatenated without spacing
  • Array with one element - returns that element (no separator added)
  • Empty array - returns empty string

Usage Examples​

Example 1: Join with Comma​

  • Elements: ["Apple", "Banana", "Orange"]
  • Separator: ", "
  • Result: "Apple, Banana, Orange"

Example 2: Join File Path​

  • Elements: ["home", "user", "documents"]
  • Separator: "/"
  • Result: "home/user/documents"

Example 3: Join with No Separator​

  • Elements: ["Hello", "World"]
  • Separator: ""
  • Result: "HelloWorld"

Example 4: Join CSV Fields​

  • Elements: ["John", "Doe", "john@example.com"]
  • Separator: ","
  • Result: "John,Doe,john@example.com"

Example 5: Join with Custom Elements​

  • Elements: ["A", "B"]
  • Custom Elements: ["C", "D"]
  • Separator: "-"
  • Result: "A-B-C-D"

Tips​

  • Use for creating CSV lines from field arrays
  • Perfect for building file paths from directory arrays
  • Great for creating delimited strings
  • Opposite operation of Split node
  • Empty separator creates concatenated string
  • Use custom elements to add static values to the array
  • Separator appears between elements, not at start or end

Common Errors and Solutions​

Error: Separator at beginning or end of result

  • Cause: Empty string in array
  • Solution: Filter out empty strings before joining

Error: Need to join with different separators

  • Cause: Single separator applies to all elements
  • Solution: Use multiple Join operations or Template node

Error: Custom Elements not appearing

  • Cause: Not properly configured in node
  • Solution: Check that Custom Elements are added in node configuration

Practical RPA Examples​

Example: Create CSV Line​

Elements: ["John", "Doe", "30", "New York"]
Separator: ","
Result: "John,Doe,30,New York"
Use: Write to CSV file

Example: Build File Path​

Elements: ["C:", "Users", "Documents", "file.txt"]
Separator: "\\"
Result: "C:\\Users\\Documents\\file.txt"
Use: Windows file path

Example: Create Display List​

Elements: ["Item 1", "Item 2", "Item 3"]
Separator: ", "
Result: "Item 1, Item 2, Item 3"
Use: Display items in UI

Example: Build URL​

Elements: ["https://api.example.com", "v1", "users", "123"]
Separator: "/"
Result: "https://api.example.com/v1/users/123"
Use: Construct API endpoint

Example: Create Tag List​

Elements: ["javascript", "nodejs", "react"]
Separator: ", #"
Custom Element: "#" (prefix)
Result: "#javascript, #nodejs, #react"
Use: Social media hashtags

Example: Format Full Name​

Elements: ["Mr", "John", "Smith"]
Separator: " "
Result: "Mr John Smith"
Use: Display formatted name

Pattern: Split and Rejoin​

Transform delimited data:

Step 1: Split "a,b,c" by "," → ["a", "b", "c"]
Step 2: Process each element (uppercase, trim, etc.)
Step 3: Join with different separator " | " → "A | B | C"

Pattern: Build Formatted Lists​

Create human-readable lists:

Elements: ["Apple", "Banana", "Orange"]
Separator: ", "
Result: "Apple, Banana, Orange"

For last item with "and":
1. Get all but last → "Apple, Banana"
2. Get last → "Orange"
3. Concatenate → "Apple, Banana and Orange"

Pattern: Create Sentences​

Build sentences from parts:

Elements: ["The", "quick", "brown", "fox"]
Separator: " "
Result: "The quick brown fox"

Working with Custom Elements​

Adding Static Prefix/Suffix​

Elements: ["item1", "item2"]
Custom Elements: ["prefix-"] (add at start)
Separator: ", "
Result: "prefix-item1, item2" (if configured correctly)

Adding Multiple Custom Elements​

Elements: ["A", "B"]
Custom Element 1: "C"
Custom Element 2: "D"
Separator: "-"
Result: "A-B-C-D"

Combining with Split​

Reverse Operation​

Original: "A,B,C"
Split by ",": ["A", "B", "C"]
Join with ", ": "A, B, C"

Transform Separators​

Original: "A|B|C"
Split by "|": ["A", "B", "C"]
Join with ",": "A,B,C"

Creating Complex Formats​

CSV with Quotes​

Elements: ["John Doe", "123 Main St", "NYC"]
Process: Add quotes to each → ['"John Doe"', '"123 Main St"', '"NYC"']
Join with ",": '"John Doe","123 Main St","NYC"'

SQL IN Clause​

Elements: ["1", "2", "3"]
Add quotes: ["'1'", "'2'", "'3'"]
Join with ",": "'1','2','3'"
Use: WHERE id IN ('1','2','3')
  • Split - Opposite operation - split string into array
  • Concatenate - Join exactly two strings
  • Template - Complex string formatting
  • Replace - Modify separator after joining