Float number from CSV not working in import data

[Issa2024]

Hello this is my configuration :

i m on premise :

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

My problem concerns the import of numerical values in decimal format that isn’t working. N8N is not retrieving values of type 2.4 as 24; instead, the decimal point disappears. How can I resolve this issue?

This my data csv files :

ID;MTT
1;3,4
1;45,5
1;56,6
2;43,77
3;66,44
2;4,5

and this is my workflow

This is the n8N traitement node and all float number are gone :

how fix this please ?

[barn4k]

hello @Issa2024

I don’t see any isssues with it

But you should use Extract from File instead of Spreadsheet File node ( where did you get it? )

[Issa2024]

Hello

thanks that’s works so when extract file csv we have to use extract from file and not spreesheet

Thanks

[Issa2024]

@Issa2024

Hello this is my configuration :

i m on premise :

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

Hello the sum not working

why the number is not detectable like a float ?
can we user summarize node or i have to make it with code node ?

Thanks

[barn4k]

Open the Schema tab and check the type of MTT variable. it’s most likely a string.

You can fix the value with an Edit Fields node