Filter columns by month and count rows for each filter

THE ROBOT IS READING AN EXCEL COLUMN, WHICH CONTAINS SEVERAL DATES, I NEED TO FILTER THESE DATES PER MONTH

FOR EXAMPLE:

DATA COLUMN CONTAINS 02 - EQUIVALENT TO FEBRUARY MONTH. THEN I PLACED AN ASSIGN FOR THE ROBOT TO COUNT AS FILTER LINES AND TO WRITE AND WRITE IN ANOTHER EXCEL TABLE.

image

str_int_mes is a count variavel that start with 1 and finish with 12

And this in for each, because it should count as lines of all month that appear in this table column.

The problem, is that filter dont work, I Have one assing that count de rows, but results every filters is “0”, the result is incorrect.

Hello @lourena.coutinho ,

Can you put a screenshot with your workflow, to better understand whats there?
If is possible of course.

Vasile.

Contains won’t work. Remember 12 (dec)contains 1 and 2 like jan and feb

Try use equals

Hi @josephatomwanzia

Can you show us the excel file and workflow for better understanding… thanks

Change to equals