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 $TableRowo0]$ 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 

Do you have any other Log text to file actions other than on line 14? Your Steps are collapsed, so I can’t tell.

Thank you. The template CSV file has a header… and so does the table of data you are capturing from the web page. That’s why you were getting duplicate headers.

To resolve this, leave your Log text to file as “append”, and add another action after step 10: Data Table: Delete Row. Remove row index 0 (zero). This removes the header row from the table you captured in step 10.

Not sure if this is what you mean

did step above and got this error 

The parameters should be your table name for the first field, and the number zero (0) for the index.

smh...finally got the duplicate row removed. Thank you. I thought I had to copy the variable of the index 0.

I notified the person who recorded the video. We will have this step added to the lesson soon. Apologies for the difficulties.

Thank you again and no worries...sometimes it is hard to explain things in a forum to where a person gets stuck at. But I appreciate all of your help