Hi,
What is the best way to pull data from certain columns based upon a specifics within another column - see my example below. I am trying to recreate the "New Field" in alteryx, essentially doing a Hlookup on columns RP_001-RP_011 using data from the "RP" column.
My data set has over 120 columns.
Thank you,
Sonya
Solved! Go to Solution.
This is how I solved it...
Cheers,
Mark
Thanks, I am having trouble opening the attachment.
Which version of alteryx designer are you using ?
V11.0.3.25674
I lowered my version to 8.1 for you.
Thank you very much! This seemed to work!
I'm having some problems with: hlookup trong excel
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |