There is option “Empty Row behavior” in the For each excel row acitivity in studiox.
In your case we have to select the dropdown as process to not to ignore the empty cells. if you enable that option your work flow will work as expected. Thanks.
What i want is to delete the entire rows which are blanks in column Q. If there is value in column Q then that respective row for the entire sheet to be kept
Now everything is perfect except at position field in the delete row activity. In your case we have to enter current index in the at position to delete that row alone which is having blank in the Q column.
Delete rows activity in the for each row loop is behaving little odd.
we have to use filter and delete rows activities to remove the blank rows by checking on the Meeting Date column.
i have created sample work flow for your Question. please find the attached code and try the same steps in your process and let me know if it works. thanks.