Actually I am in progress of deleting past 7 days record in excel sheet with date may i know how to get the date and delete past 7 days in automation anywhere when i try to delete without loop it just delete 1 record when with in the loop it just delete all the record
Kindly give me a flow
Page 1 / 1
how to delete rows with the date in excel
Actually I am in progress of deleting past 7 days record in excel sheet with date may i know how to get the date and delete past 7 days in automation anywhere when i try to delete without loop it just delete 1 record when with in the loop it just delete all the record
Kindly give me a flow
Hi @abishek22225 , you can use Get Current Date, Subtract Days -7 then compare with the date present in the excel, if match is found then delete the row.
Thanks for the reply when i have done this all that you said but i have a problem in when it delete the 5 row the 6 row place it in 5 row so it was not deleting the row properly what should i do now
kindly help me in this
You can save the previous row data in a variable and once you delete and go to the next iteration, you can initially check for the previous row data and then the current row. This will work for the row getting shifted up.
@Zaid Chougle Thank you sir , Actually I am new to Automation Anywhere kindly tell me the flow and how it works in detail
Sure @abishek22225,
Initially there will be a loop for each row in excel → At the end of the loop please save the entire row / date in a variable. In the next iteration it will check for current row and previous row as well(this is for the row getting shifted up post deletion).
Check the logic it will work.
Ok Sir Thank you
@Zaid Chougle sir it showing error in the loop kindly help me to solve it
@abishek22225 , can you please share the Screenshot of the logic
@abishek22225 ,
First → Use loop (For each row in excel advanced)
Second → Get System Date time, then subtract it by 7 Days.
Third→ Use If condition( check variable date == subtracted date), delete row.
Fourth → Use if condition (check previous row date == subtracted date), delete row.
Fifth → Assign Current Row to a variable, example (Previous_Row).
Another logic is what you can do is @abishek22225, you can use while loop, after the end of the while loop you can get the shifted date and that will again check the while loop, once the condition is false than it will come out of the while loop and traverse in the excel loop
Thank you for this Answer sir now I have a logic that we can see the details of student present for example : There is birthday for student in college i need to send wish throug mail and save in another excel who has birthday if there is no birthday it shoud enter no one has birthday in that log now there are 60 students. loop was checking the 60 students and there is birthday for one student it enter correctly in log but the 59 don’t have birthday it enter in the log that no one has birthday what should i do now?