Hi all,
In input excel sheet Input.xlsx (15.4 KB) there are three columns.Now, I am trying to check the condition i.e, If "In Duration (In Hrs) contains 00:00 AND Punch records is empty then in the output sheet output.xlsx (8.6 KB) the leaves column value should increment according to the employee code. Every day the input sheet changes.
Please help me out.
Thanks in advance
Hi @Sharmila
Use read range
For each in Dt
row(“InDuration”).toStringContains(“00:00”) and string.isEmpty(row(“ColumnName”).ToString
Thanks
Ashwin S
Thanks for your reply @AshwinS2,
yes, i can able to check this condition, but how can i increment the value of the leaves column in output sheet
Hi @Sharmila
Set a flag as counter and try to increement the counter and pass it to write range
Thanks
Ashwin S
Hi @Sharmila,
I’m attaching a .zip file where you can find your solution.
Forum(Sharmila).zip (23.5 KB)
Thanks & Regards,
Apurba
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.