Data order

[pvolpert]

I am looking for a way to sort 5000 plus records to weekday order UMTWRFS.

MTWRF
MWF
M
TR
WRF
TR
WFU
MTWRF
TR
R
WRFSUM
MTWRF
MTWRF

[apathetichell]

Could you provide a jot more detail - do you want records repeating in a set order (1-5,1-5,1-5).

How should something like MTWRF be sorts vis-a-vis something like MWF?

[pvolpert]

These are delivery days and I have them sorted to columns based on the shipped days. 

In these two examples-

WFU

TWRFM

TWRFSU

I have a solution for join query problem now by using the transpose tool to create a new line against the route name.

But I would still like to know if there is a way for just the field to be changed to this result-

UWF

MTWRF

UTWRFS

[atcodedog05 · Accepted solution]

Hi @pvolpert 

Here is how you can do it.

Workflow:

1. I am using your order UMTWRFS to create a order table. I do this by split each char to separate row and assigning record ID

2. I am assign an ID for the input rows so that i can split it and merge it back again

3. Using Find & Replace to get the order.

4. Sort ascending based on order.

5. Merge back maintain the order using ID as key

Hope this helps 🙂

[pvolpert]

Thank you!