I have a excel file (SS2) containing employee id, Department and its Active/ Inactive status (0 or 1)
i am creating a bot to fetch all the active(1) employees only and paste it somewhere.
I want to skip that particular iteration if bot finds any employee status as inactive(0), So is there any function for this requirement (Which i will implement instead of Expression value after ELSE condition in the workflow in the attached screenshot i.e. SS1)
One more thing,
Current workflow will ignore the row if the status has a null value, But I also want to fetch that row and add to a variable (for eg in variable ‘nulls’ in Recorder variables in SS1) for creating a log file.
But i am unable to fetch that row.