Getting Started with Building an Automation

Log text to file will append or overwrite the file, depending on the option in your last screen shot. When doing this kind of logging, I typically change the Log text to file that writes the headers to “Overwrite existing log file”. This ensures a clean file for each run with no duplicated headers.

Thank you for the reply. I forgot to mention that I did try flipping those statuses. I originally had the option set to “Append to existing log file” and then tried to use the “ Overwrite existing log file” and the results only gave me one record when there are actually 16 records for the status Complete and In Progress

Correct. Only change the one writing the header to “overwrite”, keeping the one writing the data to “append”.

I think I am confused. Are you talking about this section? Because choosing Append gives me the duplicate headers and choosing Overwrite I get the screen shot that shows one row without the header and the other 15 rows. I guess I am still not comprehending 

Yes. Your first “Log text to file” writes the headers to the file. Mark that as “Overwrite existing log file”.

The second “Log text to file” (shown above) needs to be set to “Append to existing log file”.

If your automation only has one Log text to file, just set it to “Append” and clear out the file each time manually. (There are other ways to do that as well.)

I have deleted the excel file and went and ran the bot with the “Append to existing log file” and then deleted the file again completely and re-ran the bot with the second option “Overwrite existing log file” but still get either One...duplicate header listed or two...no header and one row. I am still lost on following with your response. In creating the homework for the Delay status I have everything the same except changing the condition to not equal to Delayed 

Hi @none 4934 ,

I hope the $TableRow[0]$ in here contains the header values. If that's so, you should not mention that while Appending to the file. This will duplicate the Header values.

Hi @Padmakumar capture the table that includes the header but I tried both append to existing log file and tried again with overwrite existing log file as shown above in screen shots. I created two different bots, one was following the demo which worked fine. The second bot is the homework exercise, is where the header duplicated it’s self. 

both bots are both created the same except I put the homework condition for the IF package set to does not equal to delayed 

@Aaron.Gleason