Forum Discussion
Helper IExcel import - Columns missing data
A couple of things:
- Adding a column as you did will always add that column even if it doesn't exist in the source. It will, as you discovered, return NULL.
- I suspect your source data is different and not actually "MPG" in all of the files. And Power Query is case sensitive, so MPG will not import the mpg column, or the Mpg column.
Go back to your excel files and look at the exact column headings and see what they are.
If you find that the columns are changing in name by file but not in their index number - i.e. the MPG data you want is always in the 13th column, but may have a different heading, then it becomes a bit trickier to find, but still doable, but I don't want to go down that path until you've confirmed exactly what is going on.
Community SupportHi bilogin ,
I am not clear about your requirement, did you mean that when you combine sheets , the data still missing in power query? Please makse sure the data type is correct and make sure whether the column name are the same, or refresh the datasource to see whether it work or not. By the way, if possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.