Aggregate node not dropping null values when automatically executed in workflow

Questions
1

I have been trying to use the aggregate node to remove “null” values but got stuck.

The node removes the "null values when i click “Test Step”, but it does not remove “null” values when it is executed through a workflow i.e by clicking "Test Workflow

Any help would be greatly appeciated. I’m totally new to n8n.

  • n8n version: 1.77.3
  • Database : PostgreSQL
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Ubuntu Server 24.04

This is my workflow:

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
4

Hi @KC_Paite

Thanks for posting here and welcome to the community! :cake:

You can try a little brute force approach by adding Split Out Nodes, Filter Nodes and a Merge Node :wink:

5

Easier to remove nulls with the code node :slight_smile:

6

Thanks, that’s what i did for the time being. Wish somebody would fix the node.

7

wanted a no-code solution. Thanks anyway. Temporarily solved with extra processing nodes.

8

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