Hello,
I have a large matrix (as depicted below), and I would like to search each Cell-ID column for a specific gene value. If that value is met, I accept the whole column data and then move on to the next one. I.e. if [gene1732] > 0.5 then return [Cell-ID1] else null endif.
Is there a way to return the whole columns data based on a single gene value? I am attempting to use a Dynamic Select tool that has been modified to accept 2 inputs. My workflow first identifies the [Cell-ID]s that meet the criteria, but I am stuck as to why I am getting an error for the modified Dynamic Select macro... Here are the two errors I am getting:
Error: 20181205-DynamicSelectName (23): Record #1: Tool #1: Parse Error at char(18): Unknown variable "TAAACCGAGAAGGACA"
Error: 20181205-DynamicSelectName (23): The output connection "Output4" was not valid
Gene Cell-ID1 Cell-ID2 Cell-ID3 ....Cell-ID34,766
1 -.00045 0.1702. -.005
2
3
...
21,668
After sorting
Gene Cell-ID751 Cell-ID1422 Cell-I1912 ....Cell-ID12,242
1
2
3
...
21,668
Attached is the workflow, and a modified one that is smaller so I can upload
