Lookup Value in columns but return field name

[JacobPang]

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

Item	Cost
Apple	1
Orange	2
Carrot	3
Lettuce	4

Dataset 2

Fruit	Vegetable
Apple	Carrot
Orange	Lettuce

Intended result

Item	Cost
Fruit	1
Fruit	2
Vegetable	3
Vegetable	4

Thanks in advance!!

[AhmedAlZabidi · Accepted solution]

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]

Thank you very much. That was amazing 😄