Hi All,
Need some help sorting data based on a different column and previous row.
Attached is a sample of what the data looks like and what I want to achieve as a result.
Thanks in Advance
Solved! Go to Solution.
I'd create a metadata input that includes a SORT_ORDER field for column A. Home = 0, First = 1 etcetera. Using a Find Replace tool, I'd add that field to the initial table and sort on the new SORT_ORDER field. Once the field is used, you can de-Select it.
Cheers,
Mark
Any luck with this? I also have data that has not been sorted, my project requires data in a similar format:
Raw Data
Starting Station | Stopping Station |
Sandringham | Hampton |
Brighton | Elsternwick |
Ripponlea | Gardenvale |
Hampton | Brighton |
Elsternwick | Ripponlea |
Sorted Data - Objective
Starting Station | Stopping Station | Journey |
Sandringham | Hampton | 1 |
Hampton | Brighton | 2 |
Brighton | Elsternwick | 3 |
Elsternwick | Ripponlea | 4 |
Ripponlea | Gardenvale | 5 |
Can anyone help us with an example workflow?
Thank you very much!
Hey ReinierK,
Just wanted to confirm with you that the following is the logic behind the workflow:
- You have programmed the workflow such that the input list is effectively joining for the second column's record in the first column using the sample tool to skip the first row and attaching it back into the list to find itself...
- The iterative macro is required because you are effectively using the 2nd columns first row to do a vlookup (in excel land) of itself in the first column which will then loop the "remaining" records to find itself again...
Just wondering how I can explain the logic behind this to others...keen to hear your thoughts & explanation.