Hlookup

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

Sample data.xlsx

Preparation

Accepted answers

MarqueeCrew

I lowered my version to 8.1 for you.

Hlookup v8_1.yxmd

All comments

MarqueeCrew

@swhitmeyer,

This is how I solved it...

Select (to remove the answer from the data)
Transpose (keep the question column as the key and all other lookups as data)
Filter (find where question column is contained in the name of the header)
- This results in finding the right row data for the column.
Select (to rename the output column to protect the innocent)