Sort in Trifacta has issues

[WuCong]

Hi Team,

I want to sort the information like below.

I have sorted by Visit  Period,

sort order: {Site Number},{Subject Number},{Visit Period}

While the below screenshot did not get the expected result.

Expected Result:

Visit Period

Visit 2-4

Visit 4-6

Visit 6-7

Visit 7-8

Regards

Caroline

[nkuipers]

Hi @WuCong,

What is the edition and version of the Trifacta product that you are using? Please let me know.

In the meantime, I tried testing with the attached "dummy data" file and the rows were sorted correctly (see screenshots). I encourage you to try the same, and let me know how it goes.

With the live data, is it possible that the earlier sort order columns are taking precedence and disrupting the expected sort with respect to Visit Period?

[WuCong]

Version :7.6.2+471.20220609040621.a3508ff

and before we sort ,we change all varibales to string ,then sort by serval fields ,and output to csv

sometime it works,sometimes it did not work.

it confused us.

our inforamion like such below.

Site Number	Subject Number	Visit Period
Test-MIG3	10000000002	Visit 4-6
Test-MIG3	10000000002	Visit 6-7
Test-MIG3	10000000004	Visit 4-6
Test-MIG3	10000000004	Visit 6-7
Test-MIG3	10000000123	Visit 4-6
Test-MIG3	10000000124	Visit 4-6
Test-MIG3	10000000124	Visit 6-7
Test-MIG3	10000000124	Visit 7-8

[nkuipers]

Hi @WuCong,

I created a new test file with the data in your post -- see attached. In my testing -- sorting by Site Number, Subject Number and then Visit Period -- the results are correct (see screenshot). What is the result if you upload my test file into a new flow, and then add a recipe with the sort step? Please let me know.

Please also note that 7.6 entered end-of-life in April 2021 and is no longer supported.

Cheers,

Nathanael