Debugging my first work process as person with no coding knowledge

Hi everyone, I created my first excel process ;The automation process that merges data from multiple Excel reports into one and creates a pivot table and a chart based on the consolidated data. It was successful till I noticed the data from the input file had been copied 5 times, making the output longer than it should. I need help debugging and also a few tips and tricks when it comes to debugging. Thank you.

Hi @Asantewaa_Mantey :slight_smile:
Before writing the Excel, did you delete the Excel file created in the previous run?
If you do not delete it, it will overwrite that file in each run

Thank you so much @HaticeKubraYilmaz . I actually did not. Can you please walk me through it.

First of all, I’m sorry for the late response @Asantewaa_Mantey :cherry_blossom:

If you have a stream where you will create any file, it would be a good idea to check in case there is a previous file with the same name. To do this, you can add a short check at the beginning of the flow, such as delete if file exists.