This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am new to Alteryx and this question seems basic for my genetic analysis. I need to compare current cell_id row value to cell_id next value, and if equal, add the next umi row value to a new column on the same row, if not equal, return 0. As you can see from the output, the conditional always returns as not equal. I've tried a couple different variations. See workflow attached:
I think the issue with your current workflow is that you are grouping by the gene_name and umi columns in your multi-row formula. If you remove these groups I think that it works as expected.
The problem here is that the gene_name changes even in the same cell_id, and each row has its own unique umi, so these group bys essentially cause subgroups to exist in your data that never have the same cell_id.