Question: Selecting columns to sort
0
gravatar for stacey.cook
2.3 years ago by
stacey.cook0 wrote:

I have joined 2 datasets using column 1, now that they are joined I want to sort using culumn 2. When I perform the sort on column 2 it keeps column one sorted the same way the data was output from the join and only sorts colum two within the column 1 sort.

Example (imagine number column and letter column) data after the join 1 b 1 a 2 c 2 b 2 a 3 b 4 a

What I want 1 a 2 a 4 a 1 b 2 b 3 b 2 c

what galaxy is giving me when i sort using column 2

1 a 1 b 2 a 2 b 2 c 3 b 4 a

can anyone help me perform the sort ignoring column 1? while still keeping the data there?

Galaxy version 16.07.rc1 browser chrome

cheers.

galaxy • 639 views
ADD COMMENTlink modified 2.3 years ago by Jennifer Hillman Jackson25k • written 2.3 years ago by stacey.cook0
0
gravatar for Jennifer Hillman Jackson
2.3 years ago by
United States
Jennifer Hillman Jackson25k wrote:

Hello,

The sort is likely set at numerical by ascending. Instead use alphabetical by ascending since the data value is not a number. I just tested this on your data to double check and this works to produce the desired sort order (meaning: no new problems with the tool).

Thanks, Jen, Galaxy team

ADD COMMENTlink written 2.3 years ago by Jennifer Hillman Jackson25k
Please log in to add an answer.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 16.09
Traffic: 179 users visited in the last hour