Forum Discussion
Error while combining different excel files
Hi Ross73312,
Thanks for reply. I have followed the below steps :
1. The excel files are fetched from a folder. So the GetData -> Folder-> Combine& Edit
2. Choose "First File" as an example file. Click OK.
3. I removed top 6 rows from the "Transform Sample file from Test Report". Then "Use First rows as Headers" followed by "Unpivoting the Columns". Now I am getting error related to 2nd excel files and not able to find data related to it.
1st excel sheetI am not sure what step I need to follow to merge/ combine both the files without any errors.
Thanks
My recommandation is to bring each file in one by one. Get each one into the format you are happy with. Do an append only after you have checked each file is now in the desired matching format. This will let you step through the problems more easily if they arise.
Hi,
In future we are expecting more excel files to be updated in the folder. So bringing each file one by one, transform each files and appending will be repetitive task and I am trying to avoid the same.
Thanks
Based on your screenshots, your files differ in same fashion. From what i can see you need to remove the top X rows, but X is different in each file. You might find you have to deal with each file individually to hand code the required transformations.
Hi Ross73312,
What if the "top X" rows are same for both the files? I am getting the same error.