Latest
Open
RNA-Seq
ChIP-Seq
SNP
Assembly
Forum
Planet
All »
Home
Log In
Question: Confusion on setting up workflow to compare two sources
0
gravatar for griffin
3.8 years ago by
griffin • 0
United States
griffin • 0 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 COMMENT • link •
modified 3.8 years ago by Jennifer Hillman Jackson ♦ 25k • written 3.8 years ago by griffin • 0
1

Hi Jennifer,

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

ADD REPLY • link written 3.8 years ago by Bjoern Gruening ♦ 5.1k
3
gravatar for Jennifer Hillman Jackson
3.8 years ago by
Jennifer Hillman Jackson ♦ 25k
United States
Jennifer Hillman Jackson ♦ 25k 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 COMMENT • link written 3.8 years ago by Jennifer Hillman Jackson ♦ 25k

Thank you!

ADD REPLY • link written 3.8 years ago by griffin • 0
Please log in to add an answer.

Similar posts • Search »

Content
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