I have 3 excel file with the same column headers, I want to append the data from all this 3 excel to one excel file
However when I try that, it appends even the headers.
did you use append range activity? What was implemented so far?
Yes, i have used append range but its getting the column headers after appending the data for each file
Here is a dummy example of what the excel file looks like when I use append
So i don’t want to have a repeat of the column headers, it should just be at the top only
and when read in the data was addHeaders activated for a read range. Otherwise show some details from the implementation and flow
Its not working, the data keep repeating itself
Its better to use an excel template with the headers. For each automation you can copy that template to a folder and use that file to append the range. In the append range enable “Add header”