Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
RÉSOLU

Hlookup

swhitmeyer
Astéroïde

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

9 RÉPONSES 9
MarqueeCrew
20 - Arcturus
20 - Arcturus

@swhitmeyer,

 

Hlookup.gif

 

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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
ponraj
Pulsar

Hi Sonya,

 

Here is solution for your case.  Hope it helps. 

 

WorkflowWorkflowResultsResults

swhitmeyer
Astéroïde

Thanks, I am having trouble opening the attachment.

ponraj
Pulsar

Which version of alteryx designer are you using ?

swhitmeyer
Astéroïde

V11.0.3.25674

MarqueeCrew
20 - Arcturus
20 - Arcturus

I lowered my version to 8.1 for you.

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
ponraj
Pulsar

Just see if you are able to open this workflow

swhitmeyer
Astéroïde

Thank you very much! This seemed to work!

anhd389
Atome

I'm having some problems with: hlookup trong excel

Étiquettes