CN

A further innovation in MashZone 2.1 is the creation of routes. Now, you can connect multiple points with one another to create a complete route. I will explain how to create a route with the following example.

The first step is to create the data. To do so, I will use an Excel sheet that contains the individual cities needed for calculating the route. To specify the order of the individual points you must create a column with the name "ID". You can also differentiate the routes from one another. This is done with the additional column "Route".

First, create a data feed and import the document.

Then, insert a geocoding operator that searches for the geocoordinates of all the cities.

After this, create a further operator that is responsible for calculating the route. It calculates a single route string from all of the geocoordinates with a special algorithm. This helps save space.

The "Mode" setting allows you to create different types of routes. In my example, we are using "Entire Route" so that a line is generated between the start and end point.

"Index column" sorts all intermediate points, so that the route is connected according to the defined scheme.

Latitude and Longitude receive the values calculated by the "Geocoding" operator. "Route identification columns" is responsible for differentiating each route. If you only want one route, you can leave the value {None}.

If there are too many waypoints, you can improve them under the "Route Optimization" item. This allows you to streamline detailed routes with the help of a tolerance or just leave out a maximum number of waypoints. In addition, it is also possible to optimize the display of the route to the size of the map used. When you have made all of these settings, the operator can be connected to the output.

In the second step, open the Composer and create a table and the Google Maps map. Enter the following data into the table and connect the column "Route" with Column 1 to display the route. RouteID (1,2,3) should also be connected with an invisible operator. This invisible operator is new and allows extended filtering.

Now switch to the Layers level and create a new route.

Then jump to the data assignment and connect the Route Result_1 with Lines. In order to filter between the routes, connect the table with the map. This compares the RouteID with the Google Map.

 

Here is the final example:

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • ПЦ
  • CR
  • BH
  • Profile picture for user Ivan.Ivanov.softwareag.com
  • Profile picture for user mscheid
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock