Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Splitting Data into two rows

Toby_VAA
5 - Atom

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 

 

RecordIDCostOriginDestinationOrigin LatOrigin LongDest LatDest Long
1300LGWANU51.14810181-0.19027799417.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 

 

RecordIDCostOriginDestinationLat LongPath
1300LGWANU51.14810181-0.1902779941
1300LGWANU17.1367-61.7927022

 

Any help would be greatly appreciated

 

Thanks

 

Toby

 

3 REPLIES 3
mborriero
11 - Bolide

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.

 

 

Toby_VAA
5 - Atom

Thanks, worked perfectly!

Joe_Mako
12 - Quasar

Another option is to use the Arrange tool:

arrange.png

Labels