Check the condition in two columns and increment the value in another column

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

Dear @Sharmila Please find the Solution. UpdateEMPLeaveBalance.zip (33.3 KB)

Hi @Sharmila,

I’m attaching a .zip file where you can find your solution.
Forum(Sharmila).zip (23.5 KB)

Thanks & Regards,
Apurba

Thankyou @sunil_singh1

Thankyou @apurba2samanta

Hi @Sharmila,

Always most welcome.:slightly_smiling_face:

Thanks & Regards,
Apurba

UpdateEMPLeaveBalance.zip (35.5 KB)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.