argument list too long for "Select data"

select
#1

Hello

I am trying to get certain genes from a large file. My list consists of about 12 thousand genes, which I have tried to get using the Select function with the arguments ’

Gene1+|Gene2+|...

But when I executed it, an error messaged said my list of arguments is too long.
What are my alternatives for getting these 12 thousand genes?

0 Likes

#2

Probably the Join two files tool is what you need?

0 Likes

#3

hello wm75
do you mean first adding a column with a string on the genes I want and filtering through that string?

0 Likes

#4

Look at that tool’s interface: it expects two input datasets. One would be the one you want to filter, the other one a file with a single column listing the genes you’re interested in. Then you choose to join only on keys/genes found in both inputs. This will leave you with a duplicated Gene column I think, but that’s trivial to remove using a Cut tool.

0 Likes