I need to import tables from 110 web links. Is there a way I can write a script to get those tables?
I do not want to fetch tables from one link at a time?
Example of the links are as follows:
So i want to write While Do script and use it to get the data.
What I would recommend that you do is create queries for two of the entries and then in one of the queries, merge them together. You can follow the instructions in my article here:
Once you have the M code, then write a script to generate the M code for merging all 110 web link sources. Create a blank query and paste in the generated M code.
Proud to be a Datanaut!