Hlookup

[swhitmeyer]

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

[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)

Cheers,

Mark

[ponraj]

Hi Sonya,

Here is solution for your case.  Hope it helps. 

WorkflowResults

[swhitmeyer]

Thanks, I am having trouble opening the attachment.

[ponraj]

Which version of alteryx designer are you using ?

[swhitmeyer]

V11.0.3.25674

[MarqueeCrew · Accepted solution]

I lowered my version to 8.1 for you.

[ponraj]

Just see if you are able to open this workflow

[swhitmeyer]

Thank you very much! This seemed to work!