Forum Discussion
XML/HTML Column Headings
Hi - thanks for the response. The html files are extracted in the below format (I apologise for the screenshot, I can't scrub the names from the data due to the file type)...
I am unable to amend the output of the files, so I am needing to amend the data after this point. It shows the date, and then the class attandance marks below this.
When pulling this into power query, it amends the headers automatically to the below:
This then obviously prevents the next files headers matching up. My plan is to utlise the first column as the name of the file, creating a "week beginning" column. My ideal sheet would look like the below:
I'm not fussy on the exact column names, but obviously I want to collate each week's worth which is proving difficult.
Thanks
"the very first thing you need to do is unpivot these files "
So... how would I do that? I've never played with these XML / HTML files before.
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523