Visualizing Fly Paths

tableaucommunity@tableau.com — Mon, 07 Oct 2013 06:34:41 GMT

I have an SAP ERP data source, with the ODBC driver made by Starschema. I'm trying to visualize the fly paths in Tableau which are coming from ECC.

These paths are in the SPFLI table, I can query that table with a select *, no problems so far. I get the following columns:

Country from

City from

Departure time

Country to

City to

Arrival time

Distance ID (km or mi)

Fltype (null or X)

Connid (the key to connect the table with other tables like SBOOK, SFLIGHT)

Distance (the flight distance)

Flight time

I can visualize the cities, and countries by assigning them a geographic role. However I can't make routes between them. If i could double the data, in a country-city, time, order format, It wouldn't be a problem, but because of the SAP limitations It's not possible.

I can add the data source again, thus having the data available 2 times.

Any help would be much appreciated

Content in Tableau Community Forums

Visualizing Fly Paths