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

The next step is to create the concatenate, to generate the finished Wiki code, like we did with the all series database. It will be along these lines:

"|",Sequence,"||",Car,"||",Minimum number of available Races,"||",Maximum number of available Races,"||",Number of series available

Hi Michael,

I re-ran the queries this morning, all fine except for a few problems regarding the Koenigsegg One:1 as expected ...

1. The Showcase/Time-Trial tier name is 2014 Koenigsegg One:1, there was no match, so it returned <> for those 4 events ... I added it to the REPLACE list and then it worked fine.

2. The 17 new events with "?" in the R$/Fame columns returned errors because of trying to convert  a non-numeric value to a number! I think it might be a good idea to leave these in there as it's a way of finding the problems. A nice touch, PowerQuery generates an error report so you can see what went wrong. Let me know if you want me to look for "?" and replace it with 0 (thereby bypassing the error) or leave it in ... I think we should.

You mentioned generating the concatenate string. If you want me to do that in the query then please tell me EXACTLY what you want so I don't release something which is wrong. Alternatively, this is something you could add in Excel once the data has been extracted? Let me know. Also, for what should I be generating concatenated data  e.g.

 -           All Events … where it all started!

 -           All Events for all Cars

 -           Number of Groups/Series/Events for all Cars?

Your concatenate example above confused me ... you can't have a minimum and maximum number of events available for a car, you can have the number of events for a car ... or have I misunderstood your requirement?

Nick