Read many CSV files and extract data, files by files

[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

So my workflow is simple, but i m stuck, i got a directory with many csv files, and i want read all this files, sum a colum and send a html table with name of files, sum of a one column name MTT how sum all et send it to TEAMS CHAT

OK that’s work, but i got an issue.

My wrokflow give info of all csv files in one line and i need the info csv by csv files

So my Problem is here :

When i extract from file, i got all line items extract in one time, and i need them for all my csv files separed

Thanks

[ihortom]

Hey @Issa2024 , you can use Loop node to separate processing of each CSV file. Here’s a mock-up demo that conveys the idea.

[Issa2024]

Hello really thanks

but i got an issue
when i look the out the merge of u exemple :

we can see a list of item of data files that’s OK, after that the loops works properly.

So now i had my list files on the loop :

i don’t understand why the loop with u merge and list files work, and not mine ?

i can’t see the difference with the two list ?

[ihortom]

I believe the difference is in the loop. Your loop is broken. Hence iteration stops on the 1st item.

[Issa2024]

I m stuck with this :

i do’nt know how paste and share my workflow :

so i got many csv files and i want create a html table with

NameFiles SommeTotal
NomFiles1; XXX
NomFiles1; XXXX

[Issa2024]

Ok i update my workflow :

i got this result :

sum_price
3554.6299999999997

So i need to add the sum by files and not a global sum of all files

if u have an idea thanks

[Issa2024]

So my problem is here :

Why my n8n do a fusion of all data, and not play the wo files seperatly ?

THe node do a fusion off all data

and i want a table with files seperatly, i don’t understand why n8n do a fusion some time, other time works item by item, and some time do a fusion of item ?

thanks

This is workflow :

[ihortom]

@Issa2024

i don’t understand why n8n do a fusion some time, other time works item by item, and some time do a fusion of item ?

It is a good question I do not have the answer for. It seems to apply to binaries only (nodes working with binaries). However, I did show you a workaround, you just need to add the Loop node.

[Issa2024]

Hello thanks,

but not working.

the node extract from file do a fusion of all csv files in one things :

why a fusion of all csv files in one table ?

this is not what i nee d ??