I have this datatable where I have to fill out the blank rows of these columns: Type of Project, Type of Service, and Status. For the blank rows of the said columns, the values that I have to write is this:
Note: The picture above should not be written in a sheet. It is just the condition that needs to be done if the rows for Type of Project, Type of Service, and Status columns are blank.
I think I made it but when I checked the output where the rows of the said columns that have the values before running the robot disappear. In the picture below, the highlighted rows disappear after running the robot:
Are there any other activities that I have to add in my existing workflow for me to avoid the disappearance of the said highlighted rows in the picture above?
Kindly see attached files for the workflow and the excel file being used. Thank you.