1 of 1 people found this helpful
the way to address this is to UNION a copy of your data upon itself - the process is a little too long to explain here but there is a step by step video cone by Super Data Science at the link below
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Jim, so basically union the information to itself without using the lat, long and go based on the city state information with the path calculation?
I looked at that link but need to think through it more.
Thanks for the input.
when you union the data you can now break origin/destination into separate rows as needed creating the map you want
video takes about 15 min and will walk you through the process
Awesome, I watched this yesterday but it didn't click for some reason, but going through it now and I see where I made a few errors.
Appreciate the fast response.