Forum Discussion
Solved
Error while combining and transforming excel files
Hi everyone, I was trying to combine and transform multiple excel files which had names as: SalesTarget_2015, SalesTarget_2016, SalesTarget_2017, SalesTarget_2018. I wanted the result to look like t...
Hi Turtledge ,
You will need to check your source data. The load sequence is in order, which means the source data was loading up to the "SalesTarget_2015.xlsx", SalesPersonID 12, then encountered an error. It is likely the format is not aligned
Regards
KT
Hi Turtledge ,
You will need to check your source data. The load sequence is in order, which means the source data was loading up to the "SalesTarget_2015.xlsx", SalesPersonID 12, then encountered an error. It is likely the format is not aligned
Regards
KT
Thank you for the advice. I checked the source data and change the files' sheet names, then it worked perfectly