I'm analysing dock-less vehicle data whereby one row represents one trip. Among other variables, the columns include start latitude, start longitude, end latitude and end longitude. I however need two rows per trip whereby start latitude and start longitude are in the first row and end latitude and end longitude are in the second row.
I've attached a png with an example of the original data structure and desired result.
Is this possible with Alteryx?
Thanks
Solved! Go to Solution.
Hi Murphy,
Solution could look this. Hope this helps.
Hi Murphy,
below solution. Hope this helps.
if we consider data were coming 2 different files, it would be easier i think.