Hi Alan,

I get around this by using x,y to line in ESRI, but that's of no help to you.  However: if you have a time dimension set up (I see you have some shipment dates in the TDE) you could use that like this (marked in red):

But, your data needs cleansing.  I found lots of instances where the city or zip etc weren't being recognized by Tableau.  I suggest geocoding your data and using X,Y co-ordinate pairs (and that would also give you a distance calculation).

Best Regards,

Allan

Alan,

I pre-process all my data in ESRI first.  If you don't have access to ESRI, then have a look at the work Andy Kriebel did here: VizWiz: Tableau Tip: Create hub & spoke diagrams using the Path shelf - Data Visualization Done Right

Here's my method FWIW:

• Entity|StartLat|StartLong| and union with Entity|EndLat|EndLong;
• Process the points to lines using XY to line in Data Management tools in ESRI (using the Great Circle Arcs);that gives me the lines,
• Then I do ET Wizards Polyline to Point, which gives me path order.

If there is a time dimension, I replace path order.

Best Regards,

Allan

Alan,

Rather than try to figure out what isn't working from your file, see attached.  It's a simple example with a screen shot of the Tableau output/setup and the snip of the base excel file.  Compare this to the contents & setup of your files and you should see what you need to do.

You'll need to do some custom SQL against your dataset to get the data structured right.  You've attached a tde, which doesn't permit doing custom SQL against it.  What type of datasource are you using?  If a db, then model a small sample into an Excel workbook.  Custom SQL works against Excel when you use the 'Open with Legacy Connecton'.  The SQL used against an Excel source will be similar structure (but likely slightly different syntax) against your original source db.