Counting rows from a csv file

Like (0) Share

Report

Posted on 15 Jun 2021 10:22:36 by frixel

901

Hello all,

I try to make a Flow for counting rows from a csv file.

This what i make but i have the error. What goes wrong?

All responses (4)

Answers (1)

55552 667 on 31 Aug 2021 at 00:29:45

Like (0)

Report

Re: Counting rows from a csv file

Thanks, this worked for me! The only difference was that I had to subtract 2 from the total row count instead of 1. When I created the csv table (from a get rows in SQL table action), the csv table output had the header row, the data rows, then one extra blank row. Not sure what caused the blank row, but in the end, if I subtracted 2 in the final compose statement, the results were correct.
sub(length(outputs('Compose')), 2)
v-bofeng-msft on 16 Jun 2021 at 06:30:07

Like (0)

Report

Re: Counting rows from a csv file

Hi @frixel :

If you just want to get the newly created file under the specified path, you only need to sort the creation time and get the last record.For example:

In addition,this is a question unrelated to the current topic, I would suggest you to consider creating a new thread.

Best Regards,

Bof
frixel 901 on 16 Jun 2021 at 06:18:01

Like (0)

Report

Re: Counting rows from a csv file

@v-bofeng-msft

Thanks, that really helps me a lot.

Now I had designated a specific file in my flow (get file content) but how do I adjust the flow if it has to be the file that comes(new) in that folder?
Verified answer

v-bofeng-msft on 16 Jun 2021 at 02:40:34

Like (3)

Report

Re: Counting rows from a csv file

Hi @frixel :

Do you want to get the number of rows in a CSV file?

Firstly,let me explain why you encountered this problem.

The point is that the content of a CSV file is a string.

I think this link will help you a lot:

What Is a CSV File, and How Do I Open It?

Secondly,You can get the number of rows by parsing the csv text.I'v made a test for your reference:

My CSV

My Flow

The Restul:

Best Regards,

Bof