Notifications
Clear all
Power Query
4
Posts
3
Users
0
Reactions
70
Views
Topic starter
Hi Mynda,
I opened the above query but got an error as follows;
Expression.Error:The column 'Header' of the table wasn't found.
Details:
Header
Could you help me fix the error please?
Posted : 06/02/2018 6:26 pm
Hi Rosemary,
The structure from the source seems to be different than before. You have to go to the Changed Type step, and remove the missing field: {"Header", type text},
Everything else should work.
Posted : 07/02/2018 12:22 am
Topic starter
Thanks for your reply but that didn't work.
Posted : 07/02/2018 1:25 pm
Hi Rosemary,
Looks like the web page, which is the source data for that example, is no longer available. The revised file attached uses source data from the Excel file so it's not dependent on the web page anymore.
Mynda
Posted : 07/02/2018 9:52 pm
