Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Hi,
as in topic is it possible to pull out values from eg. row+3 based on specified value. (in this example I woullike to pull out the value which is 3 rows below value "Peter")
IN:
| Name |
| Peter |
| Blue |
| Green |
| Pink |
| Yellow |
| Peter |
| Yellow |
| Red |
| Purple |
| Red |
| Peter |
| Black |
| Gray |
| Orange |
| Gray |
OUT:
| New_1 |
| Pink |
| Purple |
| Orange |
Mutli-Row tool is not good for this case :(
Thanks !
Solved! Go to Solution.
Hey @Wojtek_Dz, I'd say you were on the right lines with the Multi-Row Formula. However, for this case I'd just use it to apply a flag like so:
Which we can then use as a Filter condition to remove the other records:
Following this, you can either leave it or add a select to remove the newly-created [Flag] field.
