Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Lookup Value in columns but return field name

JacobPang
5 - Atom

Hi,

 

I'm new to Alteryx and need help on my workflow.

How can I efficiently iterate through one dataset to lookup the value in another dataset and return the respective column heading it is found in?

 

Example:

Dataset 1

ItemCost
Apple1
Orange2
Carrot3
Lettuce4

 

Dataset 2

FruitVegetable
AppleCarrot
OrangeLettuce

 

Intended result

ItemCost
Fruit1
Fruit2
Vegetable3
Vegetable4

 

Thanks in advance!!

2 REPLIES 2
AhmedAlZabidi
7 - Meteor

Hello,

 

You can use "Transpose tool" to pivot the "dataset 2" then join the results with "dataset 1"

 

The attached file is the solution.

JacobPang
5 - Atom

Thank you very much. That was amazing 😄

Labels