I'm trying to get some data in a format to import to tableau for some hub spoke type diagrams.
What i have so far is data formatted like the below
RecordID | Cost | Origin | Destination | Origin Lat | Origin Long | Dest Lat | Dest Long |
1 | 300 | LGW | ANU | 51.14810181 | -0.190277994 | 17.1367 | -61.792702 |
And I need to split each row into two records and create a path id so it looks like the below - so each row would be split into a path 1 and path 2 row with origin lat and long associated with path1
RecordID | Cost | Origin | Destination | Lat | Long | Path |
1 | 300 | LGW | ANU | 51.14810181 | -0.190277994 | 1 |
1 | 300 | LGW | ANU | 17.1367 | -61.792702 | 2 |
Any help would be greatly appreciated
Thanks
Toby
Solved! Go to Solution.
Hi @Toby_VAA, please find my solution attached.
I split the file in two, one contains just origin information and the other one contains just destination information, renaming the fields Lat and Long.
I have add a formula for the path, the file with origin information has path=1, the destination one has path=2
Then I union the two file together.
Thanks, worked perfectly!