Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Search and curate large database

Highlighted
8 - 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.

 

 

Highlighted
10 - Fireball

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

Highlighted
8 - Asteroid

This worked great! Thanks for the help.

Labels