Executions in one Dataset / Table

Questions
#1

Hi, how i can put all Date from many Executions in one dataset or put it in one table ?

image

Thanks,
Stefan

#2

Here an example workflow:

{
  "nodes": [
    {
      "parameters": {
        "functionCode": "const newItems = [];\n\nfor (let i=0;i<10;i++) {\n  newItems.push({json:{i}});\n}\n\nreturn newItems;"
      },
      "name": "Function",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        450,
        300
      ]
    },
    {
      "parameters": {
        "batchSize": 1,
        "options": {}
      },
      "name": "SplitInBatches",
      "type": "n8n-nodes-base.splitInBatches",
      "typeVersion": 1,
      "position": [
        700,
        300
      ]
    },
    {
      "parameters": {
        "conditions": {
          "boolean": [
            {
              "value1": true,
              "value2": "={{$node[\"SplitInBatches\"].context[\"noItemsLeft\"]}}"
            }
          ]
        }
      },
      "name": "IF",
      "type": "n8n-nodes-base.if",
      "typeVersion": 1,
      "position": [
        900,
        450
      ]
    },
    {
      "parameters": {
        "functionCode": "const newItems = [];\n\nlet runIndex = 0;\ndo {\n  try {\n    newItems.push.apply(newItems, $items(\"SplitInBatches\", 0, runIndex++));\n  } catch (e) {\n    break;  \n  }\n} while(true);\nreturn newItems; \n"
      },
      "name": "Function1",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        1100,
        450
      ]
    }
  ],
  "connections": {
    "Function": {
      "main": [
        [
          {
            "node": "SplitInBatches",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "SplitInBatches": {
      "main": [
        [
          {
            "node": "IF",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "IF": {
      "main": [
        [
          {
            "node": "Function1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "SplitInBatches",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Microsoft SQL and multiple items
#3

Jan, your sample dont work. I would be have a list on output of all executions together.

Thanks again,
Stefan

#4

Sorry do not understand what you mean. Can you please rephrase.

#5

Jan, i would like to have the data from each execution togehter in one list to use it further or send it to a sheet.

#6

Ok then that is what my example does. What does not work for you?