Read many CSV files and extract data, files by files

Questions
1

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

image
image1554×281 30.1 KB

So my Problem is here :

image
image536×220 9.26 KB

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

2

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

3

Hello really thanks

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

image
image1722×1024 40 KB

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 :

image
image3406×1796 250 KB

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 ?

4

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

5

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

6

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

7

So my problem is here :

image
image581×308 17 KB

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

THe node do a fusion off all data

image
image3659×999 197 KB

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 :

8

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.

10

Hello thanks,

but not working.

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

image
image3001×1775 233 KB

why a fusion of all csv files in one table ?

this is not what i nee d ??