If date count is
XXX row current date count =2
YYY row current date count =3
ZZZ row current date count =3
AAA row current date count =4
In above even count is there so True
if date count
XXX row current date count =2
YYY row current date count =1
ZZZ row current date count =3
AAA row current date count =4
NO even count is there in above condition so False
Try to read data from excel using read range activity.
Use for each row loop for iterting through each element name the variable as CurrentRow.
Get the column count in your case the column starts with C, so we can skip the first two column.
you can do like this = considering data table variable as dt_data dt_data.Columns.Count -2
store this in one variable say columnCount, because now we are going to place one more loop inside the for each row loop
Now after calculating the columns, place the while loop and create a variable as an index like whileLoopIndex which will loop through the remaining column. The initial value of this index will be 1 because we have to skip the starting two cols. To start reading the values from the C column you have to read the value like this str_date = CurrentRow.ItemArray(whileLoopIndex).ToString.Split(new(){" "},StringSplitOptions.None)(1).ToString()
Assuming CurrentRow is the variable in for each row loop
this will give you the date from the cell.
After this you can place your condition for matching with currentDate like this str_date= DateTime.Now.ToString("MM.dd.yy")
if the condition matches then you can increment the counter which will indicate your current date count.
If date count is 0 for all row then you want check status= “On”?
In the above file if date count is 0 for all row then it should return yyy as output based on status=“On”
Please confirm
