Have SplitInbatches run for every input

Questions
1

Right now i have the SplitInBatches to run at 1 (Works for me to not corrupt my data)

but it only runs once, doesnt matter how much input there is

How can i make it run for each input?

2

You need to loop it!

Set your Batch Size to 1 will help in your case.

Example:

Screenshot_20201224-024221
Screenshot_20201224-0242211560Ă—720 62.7 KB

1 Like
3

Will it stop the loop when all the data is done?

4

Yes. Of course

Splitinbatch will keep executing until all input datas are completed.

5

Hmm in my case it does the first one and then cuts off, Which node would i need to connect to make it loop correctly?

1716Ă—635 63.8 KB

6

Try connecting/looping both discord to split in batch input again.

Make sure you’re setting batch size to 1

7

Okay, That redid the first one over and over so that didnt work + created a magnificent penis haha

It redid it 8 times while there are 90 inputs

8

It didn’t worked?

9

Sadly it didnt

10

This did the trick:

  "nodes": [
    {
      "parameters": {
        "batchSize": 1,
        "options": {
          "reset": false
        }
      },
      "name": "SplitInBatches",
      "type": "n8n-nodes-base.splitInBatches",
      "typeVersion": 1,
      "position": [
        1200,
        550
      ]
    },
    {
      "parameters": {},
      "name": "Loop",
      "type": "n8n-nodes-base.noOp",
      "typeVersion": 1,
      "position": [
        1200,
        700
      ]
    }
  ],
  "connections": {
    "SplitInBatches": {
      "main": [
        [
          {
            "node": "Loop",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop": {
      "main": [
        [
          {
            "node": "SplitInBatches",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}```
1 Like
11

it does loop, But i get the wrong data output so, next thing for me to figure out

1 Like
12

When i get the correct data it only executes 8 times
When i get it to execute the full 90 times i get incorrect data, Head Scratching stuff :face_with_symbols_over_mouth:

So like this i get correct data but as you see it only runs 8 times?

728Ă—491 31.5 KB

13

Turns out, When Mysql Fails to output data it thinks it’s done, Setting it to “Always Output data” makes it run

14

What you’re trying to do with MySQL node? Seems you’re trying to get data out of it. Am I right?

Explaining your use case in a detailed way can help me to understand the flow. :grin:

What you’re trying to achieve?

15

Oh i got it working now :slight_smile: I simply had to turn on the option to always output data, Otherwise the loop thinks it’s done and stops

1 Like