# Split node loses information
**URL:** https://discourse.nodered.org/t/split-node-loses-information/58117
**Category:** General
**Tags:** split
**Created:** [10 February 2022 22:42 UTC](https://discourse.nodered.org/t/split-node-loses-information/58117 "2022-02-10T22:42:09Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@t4ir1](https://discourse.nodered.org/u/t4ir1)
#### Post date: [10 February 2022 22:42 UTC](https://discourse.nodered.org/t/split-node-loses-information/58117/1 "2022-02-10T22:42:09Z")
Hello there fellow noders!
I have a flow where I query a database for some values. My query returns exactly my last 120 entries of the table in the database. I tried this a great deal of times and [it always returns an array of 120 in size](https://imgur.com/a/OtNZFC9). So far so good.
I then use the split node in order to have access to the values seperartly and I forward them further into a function to parse them into float. [It looks like this](https://imgur.com/a/fAOMTBY).
What I noticed is that at the exit of the split node, I always only get 99 objects. I don't understand why, is there a limit on how big an array can be split into separate objects? I couldn't find anythin in the documentation.
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [10 February 2022 23:03 UTC](https://discourse.nodered.org/t/split-node-loses-information/58117/2 "2022-02-10T23:03:45Z")
Hi @t4ir1
Firstly, there is no need to upload pictures to an external service - just paste then in you reply.
> [@t4ir1](#):
>
> What I noticed is that at the exit of the split node, I always only get 99 objects. I don't understand why, is there a limit on how big an array can be split into separate objects
No, there is no limit. As you haven't posted an export of your flow or showed us how the split node is setup, is difficult to say.
---
### Author:  [@t4ir1](https://discourse.nodered.org/u/t4ir1)
#### Post date: [10 February 2022 23:08 UTC](https://discourse.nodered.org/t/split-node-loses-information/58117/3 "2022-02-10T23:08:02Z")
Not having a limit is great news. Also thanks for the advice regarding the pictures, I had no idea.
Would you give me and advice on how to post an export? It's a whole lot of text.
As for the config of the node it's the default one:
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [11 February 2022 07:06 UTC](https://discourse.nodered.org/t/split-node-loses-information/58117/4 "2022-02-11T07:06:32Z")
How do you know there are only 99?
---
### Author:  [@t4ir1](https://discourse.nodered.org/u/t4ir1)
#### Post date: [11 February 2022 07:29 UTC](https://discourse.nodered.org/t/split-node-loses-information/58117/5 "2022-02-11T07:29:48Z")
I export the results to an excel sheet and count.
[Here is an output.](https://drive.google.com/file/d/16YAZgnipnZD46fIXmkvZ-Yp1vMnxthG8/view?usp=sharing)
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [11 February 2022 07:36 UTC](https://discourse.nodered.org/t/split-node-loses-information/58117/6 "2022-02-11T07:36:31Z")
> [@t4ir1](#):
>
> I export the results to an excel sheet
But how do you export to excel. What is the process you use? Using a copy and paste process? Using a CSV node? Writing to file?
You need to share as much info as possible if we are to get your problem resolved.
---
### Author:  [@t4ir1](https://discourse.nodered.org/u/t4ir1)
#### Post date: [11 February 2022 08:11 UTC](https://discourse.nodered.org/t/split-node-loses-information/58117/7 "2022-02-11T08:11:00Z")
From the circuit I pasted above, I use a debug node.
I trigger a fetch from the InfluxDB query and it prints out in the debug window. When the debug node is connected at the exit of the InfluxDB node, I see the array with the size 120, when the debug node is plugged at the end of the split node I get a listing of objects on the debug window which I copy paste into excel, create a count function for unique results and it returns 99.
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [11 February 2022 09:05 UTC](https://discourse.nodered.org/t/split-node-loses-information/58117/8 "2022-02-11T09:05:22Z")
How are you copying 96 individual messages from the debug pane?
Show us a screenshot of what you are copying
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [11 February 2022 09:17 UTC](https://discourse.nodered.org/t/split-node-loses-information/58117/9 "2022-02-11T09:17:10Z")
the debug output is deliberately limited for performance reasons.
Instead of copying from debug pane, you can use a file node to write the data to file.
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [11 February 2022 09:25 UTC](https://discourse.nodered.org/t/split-node-loses-information/58117/10 "2022-02-11T09:25:13Z")
Also feed the output of the split node directly into a Join node with default configuration and see what you get out of that.
---
### Author:  [@t4ir1](https://discourse.nodered.org/u/t4ir1)
#### Post date: [11 February 2022 11:39 UTC](https://discourse.nodered.org/t/split-node-loses-information/58117/11 "2022-02-11T11:39:37Z")
Hello again, thanks for the help so far.
You are right, the debug window does not contain all the info. I exported to a CSV and it contains infact 120 entries:
That's solved! Thank you!
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [25 February 2022 11:39 UTC](https://discourse.nodered.org/t/split-node-loses-information/58117/12 "2022-02-25T11:39:51Z")
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.