Question: Selecting columns to sort
0
gravatar for stacey.cook
2.3 years ago by
stacey.cook • 0 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 COMMENT • link • modified 2.3 years ago by Jennifer Hillman Jackson ♦ 25k • written 2.3 years ago by stacey.cook • 0
0
gravatar for Jennifer Hillman Jackson
2.3 years ago by
United States
Jennifer Hillman Jackson ♦ 25k 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 COMMENT • link written 2.3 years ago by Jennifer Hillman Jackson ♦ 25k
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