Forum Discussion

Seantoh's avatar
Seantoh
Frequent Visitor
8 years ago
Solved

How to get all the table data from a website?

Hi,   I follow the step by the tutorial given. But failed. I need to get the 4 digits data from 0000 until 9999 winning hits table. Below is my script:   let Source = Web.Page(Web.Contents("ht...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi Seantoh,

     

    I just rechecked the solution, and it still works for me. Just make sure you've renamed the function(step 1) to GetData. :smileyhappy:

     

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Seantoh,

 

I just rechecked the solution, and it still works for me. Just make sure you've renamed the function(step 1) to GetData. :smileyhappy:

 

 

Regards

Seantoh's avatar
Seantoh
Frequent Visitor
8 years ago

Hi v-ljerr-msft,

 

Sorry,i need your help again.

i done all the process, if let's say i want to count the total quantity of Number 1, 2 until 9999 (each number), and how many total hit for number 1,2 until 9999 (each number) hit in Jan, Feb, March, April until Dec?

can this all do in query editor before click apply?

Actually i did click transform, group by, count row, but after run overnight, its show me evaluate error run out of memory. sad.

please let me know if any solution. thanks

 

Regards

sean