Hello,
I have data that looks like this:
Column1 |
Entity 1 |
Entity 2 |
Entity 3 |
Entity 4 |
Entity 5 |
Entity 6 |
Entity 7 |
Entity 8 |
Entity 9 |
Entity 10 |
..... |
Entity Cons |
I want to create a formula to change "Entity Cons" to be whatever the first row of data says. In the case above, I want "Entity Cons" to say "Entity 1."
How can I go about doing this? I was thinking maybe a multi-row formula with an IIF(contains([column1],"cons"....
but I'm not sure how to get Alteryx to spit out the first record. I simplified the data here, the real data doesn't actually contain numbers 1-10, so I'm not sure how to get this formula to work.
Solved! Go to Solution.
@dataviolet
Something like this?
thank you, yes this works! thanks for helping me think of my data in a different way.
@dataviolet
Glad it helps and thank you for mark it as accept.