Forum Discussion
XML/HTML Column Headings
If these are your columns then the very first thing you need to do is unpivot these files to bring them into a usable format.
Please provide sanitized sample data that fully covers your issue (Please don't reply with "my data is sensitive and I cannot show it"). 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. Avoid posting screenshots of your source data if possible.
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
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