I am trying to load table data from a web page. It loads it in, but it comes up as two different tables in the File Wizard (@1 and @2). They are two different tables and I need them to be as such, but not sure how to load them separately as I am using the URL to load the data. I also need to just certain cells (not rows) in data transformation, but I cannot select specific ones. How do I get the tables to load separately and how do I delete the specifici cells with garbage data? Fyi, the garbage data is'Â'. I tried copying and pasting it into the field but is just doen's seem to work (I can get it to delete the rows associated with this character, but not the specific cells and I need to keep the rows as they have needed data). Below is the first table labeled as '@1'.
You would need to make changes to your script, specifically including 2 separate load statements (one for each table) and leaving out the fields you don't want to load.
Paste in your load script if you need additional clarification.
It shows that threre are about 8 tables (@1, @2, @3, etc...), but only pulls from @1 in the script. So, I am missing sevral tables and the data is not remotely formatted correctly.
I guess I don't know how to transform the data without using the wizard. I presume that there is a way to code it in the script, but I just don't have that level of expertise.
The wizard works great for getting some load statements in as a starting point, but changes to these pre-formed load statements are almost always necessary.
If you want to paste your current script in, perhaps we can help point you in the right direction.
There are 14 separate tables on this web page. If I could load them individually that would make things much easier. FYI, the wizard seems to know they are not just one as it lists them each as @1, @2, @3, etc. for each consecutive table.
The problem is more with the data than anything else. Although the page is divided into 14 HTML tables, each one of these divisions contains separate data types in what should be multiple tables. In a single column, for instance we have a combination of percentages, counts and times.
While it may be possible to transform this source data into something usable, it would take some effort and could be undone at any moment if this website changes their layout. I recommend copying each table you want to use into it's own tab in excel and using that as your data source.
Thanks Clark. I figured how to get it into my QV doc, but realized the same basic thing you just described. I am simply trying to create some sample work to assist on getting a job...and as an experienced marathoner, I understand this data. Thanks for your help!
