Hi Davide,

The tool "Text Manipulation -> Add column to an existing dataset" could be used to add in the column. This would add in the data to the end of the existing file. To rearrange, use the "Cut columns from a table" tool.


You could also create a single column file, with the repeated file name in each row, with the same number of rows as each of the 23 files and upload that. Then join this file with the 23 chrom files with "Paste two files side by side".

There are probably other ways, but I think this

This would all be manual. The re-run button (blue arrow) could be used to set up the tool form for each run, which would cut down a bit on the tediousness of running this on 23 files.

If a better way comes up, we'll send an update,

Thanks!

Jen
Galaxy team

On 3/7/12 7:15 AM, Cittaro Davide wrote:
Hi all,
I have a question about a weird usage of galaxy: suppose I have 23 files, each 
for a chromosome, suppose the dataset name (in history) contains the chromosome 
name but the dataset content don't (i.e. I only have chrom position and 2 
associated values), is there a way to add a column so that the content of the 
column contains the dataset name? In a automatic way, I mean...
i.e.

data-chr1
1000000 3.1     23
1000100 1.2     23
[…]

data-chr2
1234411 33.1    24
4225211 12.0    44
[…]

I would like them to be

data-chr1       1000000 3.1     23
data-chr1       1000100 1.2     23
[…]

data-chr2       1234411 33.1    24
data-chr2       4225211 12.0    44
[…]

So that I can merge them and strip 'data-'...
Oh, I know I can do it outside galaxy and upload the final file, but I would 
like to know if (and how) this is possible,

d

/*
Davide Cittaro, PhD

Head of Bioinformatics Core
Center for Translational Genomics and Bioinformatics
San Raffaele Scientific Institute
Via Olgettina 58
20132 Milano
Italy

Office: +39 02 26439140
Mail: cittaro.dav...@hsr.it
Skype: daweonline
*/











___________________________________________________________
The Galaxy User list should be used for the discussion of
Galaxy analysis and other features on the public server
at usegalaxy.org.  Please keep all replies on the list by
using "reply all" in your mail client.  For discussion of
local Galaxy instances and the Galaxy source code, please
use the Galaxy Development list:

   http://lists.bx.psu.edu/listinfo/galaxy-dev

To manage your subscriptions to this and other Galaxy lists,
please use the interface at:

   http://lists.bx.psu.edu/

___________________________________________________________
The Galaxy User list should be used for the discussion of
Galaxy analysis and other features on the public server
at usegalaxy.org.  Please keep all replies on the list by
using "reply all" in your mail client.  For discussion of
local Galaxy instances and the Galaxy source code, please
use the Galaxy Development list:

 http://lists.bx.psu.edu/listinfo/galaxy-dev

To manage your subscriptions to this and other Galaxy lists,
please use the interface at:

 http://lists.bx.psu.edu/

Reply via email to