4 Replies Latest reply on Feb 9, 2017 7:39 AM by Jim Dehner

    Route / Map view

    Thorsten Gfrarer

      Good afternoon I have a question on generating a Route view on a map.

       

      I have a SQL database which has routes inside it + an identifier for them... however it does not have an info on which is sector 1/2/3/4 other than the sequenece in the SQL DB.

      Unfortunately I can not modify the DB to add another column (which would be the easiest way).

       

      The may it is constructed is like this: (there are more columns)

       

      Duty IDDepartureArrivalRoute Makeup
      1NYCLAXNYC-LAX-NYC-DLM-NYC
      1LAXNYC
      NYC-LAX-NYC-DLM-NYC
      1NYCDLM
      NYC-LAX-NYC-DLM-NYC
      1DLMNYC
      NYC-LAX-NYC-DLM-NYC
      2NYCAGPNYC-AGP-NYC
      2AGPNYC
      NYC-AGP-NYC

       

      What I want Tableau tho show is if the user selects Duty ID 1.

       

      It shows the routing on the Map e.g. it shows all the airports that exist and then a line between the relevant Airports in duty 1.

       

      How can I generate this ? maybe some custom SQL?

       

      Anyone got any ideas?

       

      Thanks