This parameter block is handled by cDataSet classes and provides a mapping of fields that are required on a Google Map or its visualizations and where to find them in Excel WorkBook.
Before that can be plotted we need to look up information about the Venue and the Artist. Which columns to copy over is defined in the ‘clone’ parameter block. You can clone from as many of these inputs as you like
The definition of the source, and how to join with the transactions is in the Name parameter block. Note that Join and Transactions have no Join parameter. This is because Transactions is the source data worksheet , and Join is the worksheet to populate with the result. The Join columns need to exist in both the transaction and lookup sheet – so for example, the Artist ID column must exist in both the Transactions and Artists sheet.
Private Sub endToEnd(paramName As String) ' geocode the master googleMappingExample paramName ' join to transactions transactionJoinExample paramName ' create tabbed/viz/mapped app googleMarkingViz paramName End Sub
Note that a new master called Managers is created, accessing the same worksheet as Staff. The staff transactions dataset which is driving this, has both Employee ID and Manager ID. This syntax, Employee ID=Manager ID, is instructing the Join operation that for the Managers Master Dataset, the join needs to be between Manager ID in the Transactions sheet and Employee ID in the Staff Sheet.
The whole purpose of joining like this is to be able to use the same master dataset for multiple purposes. This means that we will also need to clone the fields and call them something different in the joined dataset, as per the two lines that are cloned from the master dataset below.
bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at http://www.mcpher.com. Permissions beyond the scope of this license may be available at code use guidelines