Log In
Register
Home
October 7, 2021
Offline
Hi,
I searched the course videos but could not find how to load HTM/HTML files into PowerQuery.
Appreciate the help.
Regards,
Ayal Telem.
Trusted Members
October 18, 2018
Offline
October 7, 2021
Offline
Hi Alan,
Thank you for your replying.
First, I cannot find "File->Import" only "File->Export". Looked both on the web the the PC version.
Second, I want to be able to use the "From Folder" features PQ has, as I will have those files coming new every day, and I want to automate the process as much as I can.
Regards,
Ayal Telem.
Moderators
January 31, 2022
Offline
In PQ you can navigate to the Folder containing your files. Press 'transform' and filter for the file extension you want to connect to. In your case ".html". Now press the 'combine' button in the Content column header and proceed.
Not sure what you want to get out of the HTML files. I have none myself that give any meaningful results. So, the least you could do is upload two or three of your HTML files and explain what you want to do with them in PQ.
October 7, 2021
Offline
Stupid me!!
Since the files are in Hebrew, I made an extensive file with screen shots explaining my problem/s, but forgot to upload it!!.
So, my problem/s are not the uploading the HTMLs to PQ, but the fact that their structure is "in the way" of the desired final result. I tried explaining my problems in details in the attached file.
Regards,
Ayal Telem.
Moderators
January 31, 2022
Offline
I'm really sorry but don't understand what I'm looking at nor what you need. It's difficult based on a picture alone.
October 7, 2021
Offline
Riny Hi,
I'll try to simplify:
- The "From Folder" connector will not reognize the headers of the table in the file.
- The row below the (unrecognized) header row should be deleted.
You cannot use the "Use first row as header" option in the sample file, and since the "Delete Rows" button doesn't have an option to delete the 2nd row only, I have to deal with these rows in the actual file, and I'm not sure it's the right place for it, nor that it will get applied for every file i'll place in the folder.
Regards,
Ayal Telem.
1 Guest(s)
