Get & Transform - Upload Tables from Websites - 3-part table only loads one part

Hi all.

This is my first post. I hope I can make it as explicit as possible.

I am using Get & Transform to load a table that has three parts. Relevant links are shown below:

http://mlb.mlb.com/stats/sortable.js...tType=hitting&page=1&ts=1493041844740&position='O'&playerType=ALL

http://mlb.mlb.com/stats/sortable.js...tType=hitting&page=2&ts=1493041933644&position='O'&playerType=ALL

http://mlb.mlb.com/stats/sortable.js...tType=hitting&page=3&ts=1493041905532&position='O'&playerType=ALL

Please notice that the links are different only by two parameters: Page and TS. The page parameter specifies the table lines to load: page 1 shows values from lines 1 to 50, page 2 shows values from lines 51 to 100, and page three the remaining lines. I have not been able to find the function of the parameter ts, but I assume it is related to date/time, as it increases with later clicks (TimeStamp?).

When i try to load to excel these three links using Get & Transform I can only manage to get the first 50 lines (first part of the table) three different times.

Please let me know how to ensure I can get the second and third parts of the tables loaded into excel.

Many thanks.

Amenus.

404 Error - Document not found

These links should work properly


http://mlb.mlb.com/stats/sortable.js...playerType=ALL

http://mlb.mlb.com/stats/sortable.js...playerType=ALL

http://mlb.mlb.com/stats/sortable.js...playerType=ALL

New Query from Web 3 times (for each link)
Combine Queries - Append
and you've 150 rows

Thanks for your reply Sandy666.

The file you sent got the same problem I have. Notice that line 50 is the same as line 1.

Francisco