Forum Discussion
Solved
Download two tables from web in one function query
Hello, I wanted to ask if it's possible to download two tables from a list of URLs in one single query? Please refer to the attached file. I have a list of URLs for different stock codes. At the mom...
nes_k4 Change the applied step in fxOther where you initially filter one table to this:
#"Filtered Rows" = Table.SelectRows(Source, each ([Id] = "cnhk-list" or [Id] = "cnhk-list2")),Now the function will load both tables and create one bigger table.
nes_k4 When you connect to that URL, it show three tables "Document", "One-time advisers" and "Regular advisers". Tick the "Select multiple items" box. Now select the two tables (see picture) you want and press transform. You'll end up with two queries that you can transform a bit and then append into one new query. If that's what you need, of course, like in the attached file.
Riny_van_Eekelenthis is great, thank you very much!