if in a summarize node you try to split by a string field filled with numbers and initial zeros, the field is treated as number
ie: a string “002020” → “2020”
To Reproduce
try with
[
{
“id”: 473,
“order”: “1.00000000000000000000”,
“Amount”: 10,
“created”: “1743796982”,
“Datacreazione”: “2025-04-04T20:03:02Z”,
“upv_cod”: “017236”
},
{
“id”: 474,
“order”: “2.00000000000000000000”,
“Amount”: 10,
“created”: “1743780153”,
“Datacreazione”: “2025-04-04T15:22:33Z”,
“upv_cod”: “004537”
}]
and summarize it
upv_cod summarize
[{
“upv_cod”: 17236,
“sum_Amount”: 10
},
{
“upv_cod”: 4537,
“sum_Amount”: 10
}]
Expected behavior
[{
“upv_cod”: “017236”,
“sum_Amount”: 10
},
{
“upv_cod”: “004537”,
“sum_Amount”: 10
}]
Operating System
debian
n8n Version
1.85.4
Node.js Version
20.19.0
Database
SQLite (default)
Execution mode
main (default)
