Hello,
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.
Kindly help
Thanks
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
yes i have checked the add headers
Here is how i have implemented it,
Hi @pattwagunyi
you can merge data table simply if you have same columns
Here I am merging multiple different months files in one file.
Systems1_MargeMonthlyReports.xaml (15.7 KB)
Its not working, the data keep repeating itself
Hello @pattwagunyi
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”
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.