community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Search and curate large database

Asteroid

Hello,

I have a large matrix that I am working with (~5.5GB), and I need to search through it and pull out specific columns. The database looks like the following:

 

Gene    Cell-ID1   Cell-ID2   Cell-ID3 ....Cell-ID34,766

1            -.00045   0.1702.    -.005

2

3

...

21,668

 

I am having trouble figuring out how to move column to column to find if a gene meets a certain numerical level, and then pulling out the column if it does. Thanks.

 

 

I think you may mean something like this:

 

Read data in, transpose it, search for values.  Workflow attached.

FindSpecificValuesSampleSS1.jpg

 

 

Results of true part of workflow result:

FindSpecificValuesSampleSS2.jpg

Asteroid

This worked great! Thanks for the help.

Labels