Help with Referencing Fields in Split Out Node

Hello everyone,

I’m currently building my own workflow but have been stuck for days due to the Splitter node.

The Problem / Error I Encountered:

Please help me set up a reference for the Split Out node.
I’m trying to create a simple index using data that contains both an ID and a name.
The issue is with the Split Out node, specifically the “Fields to Split Out” setting.

Scenario A below :
When I manually entered id,nm (without quotation marks), it worked.

Scenario B below :
I also had the same string stored as input, containing id,nm (without quotation marks). I then dragged and dropped it into the “Fields To Split Out” field, but the result was:

Question :

Any tips or advice on my workflow that would allow Scenario B to pass through the splitter successfully? Appreciate any input, thank you in advance!

Workflow :

The overview for each node is like follows :

  • Start ------> click trigger
  • Var --------> setting up variable array for names.
  • Code -----> setting up array of ids for each names from node#2
  • exc -------> Setting up a text string with the value id,nm, intended to populate the “Fields To Split Out” field in the Splitter node.
  • m1 ---------> append of arrays of var & exc
  • m2---------->append of arrays from Code & exc
  • splitter------> splitting arrays from m1 and m2.

Output from the last-node:

Output from m2:

Problem in node ‘split‘
Cannot read properties of undefined (reading ‘split’)

TypeError: Cannot read properties of undefined (reading 'split') at ExecuteContext.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Transform/SplitOut/SplitOut.node.js:138:75) at WorkflowExecute.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/execution-engine/workflow-execute.js:681:50) at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/execution-engine/workflow-execute.js:915:62 at processTicksAndRejections (node:internal/process/task_queues:95:5) at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/execution-engine/workflow-execute.js:1246:20

Information n8n setup

  • n8n version:1.89.2 (Self Hosted)
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker):
  • Operating system:[windows11]
1 Like

Hi @yohka,

when you are appending the tables together, one of the tables does not have the field exclusion, and comes up as undefined. Try merging the table outputs instead of appending. Here’s a workflow.

Best,

Robert

2 Likes

Hi @rbreen

Thanks to you, I am able to continue my workflow today!
Your suggestion worked perfectly, switching from appending to merging the tables resolved the issue right away. I really appreciate you taking the time to help and for providing the corrected workflow. That made all the difference!

Best regards,
Yohka

1 Like

@yohka

Glad to help! If you can, please mark the answer as the solution so others can benifit from it.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.