Question: Confusion on setting up workflow to compare two sources
0
gravatar for griffin
3.8 years ago by
griffin0
United States
griffin0 wrote:

Hi, I am trying to compare two excel tables (loaded through get data) but when I run the program it only allows drop down selection of a csv file that I am not interested in using. Any suggestions on how to get this to work?

 

thanks

Jennifer

galaxy • 571 views
ADD COMMENTlink modified 3.8 years ago by Jennifer Hillman Jackson25k • written 3.8 years ago by griffin0
1

Hi Jennifer,

are you really uploaded a excel file, like an .xls file?

ADD REPLYlink written 3.8 years ago by Bjoern Gruening5.1k
3
gravatar for Jennifer Hillman Jackson
3.8 years ago by
United States
Jennifer Hillman Jackson25k wrote:

Hi,

Export the data in tabular format (plain text) from Excel and load it into Galaxy that way. Make certain that it is assigned the datatype "tabular" either at upload or after. If after, or you used auto-detect and it did not label it as tabular, use the pencil icon in the upper top right corner of the dataset to reach the "Edit Attributes" form. It will appear in the middle panel with several tabs. The third one is for "Datatype". Change the type and save.

Be aware that Excel can produce hidden, problematic, characters in text output. A common one is "^m" for new lines that appear within a single cell, but there are others. Try to avoid these in Excel files that you plan to use this way, or use a text editor that has an option to display hidden characters then find/replace them with nothing (on your computer, or line-command, with a tool like vi or whatever your favorite tool is).

Hopefully this helps, Jen, Galaxy team

ADD COMMENTlink written 3.8 years ago by Jennifer Hillman Jackson25k

Thank you!

ADD REPLYlink written 3.8 years ago by griffin0
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: 146 users visited in the last hour