Forum Discussion
Data Loss Between Source and Query
I am having an issue similar to this post. My source is a folder with several Excel files. I am combining the data from all of the Excel files. when I do so everything populates as expected excep...
It appears that the header of the individual Excel files impacted this issue. Perhaps because both the header and the data were in column A? Regardless, I altered the files I was using to eliminate the header. It began to work as expected with that change.
It appears that the header of the individual Excel files impacted this issue. Perhaps because both the header and the data were in column A? Regardless, I altered the files I was using to eliminate the header. It began to work as expected with that change.