Thread:RR3 Michael P/@comment-27006659-20170319151020/@comment-30967537-20170406200428

RR3 Michael P wrote: Yes, I agree, I'm dwarfed by both of you ;)

I couldn't work out how the Events data table could be selected from the page, and suspected the quotes and collections would clutter the error trap. I went for a Idata source value, still worked very well, as most pages have a value of 4. Quicker to load too :) Michael,

Butchered is the right word!

I couldn't resist having a look at your spreadsheet.

I tidied up the Cars sheet, renamed it Series and changed the AllSeries query as necessary.

I then rewrote (wrote from scratch!) your queries/functions just as a way of trying to learn some more of the M language. The output from the query isn't exactly the same as yours but I've generated the database string in the newAllSeries spreadsheet and they're a complete match for your 5999 rows! Not sure why, but my query consistently runs 5-10% faster than yours!

I've documented the changes to your query and my new queries and functions so you should be able to work out what I'm doing and then make your changes as necessary.

I had a look at trying to pull all the series automatically from the Wiki but couldn't see a quick and easy way because of the formatting (sub-tables) which throws off PowerQuery.

Do you want me to send it to you?

Nick