Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

Alteryx Designer Desktop Discussions

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

Vlookup

Kjaer
8 - Asteroid

I have a dataset A, where I have made a filter to sort all out with Mappe = 100. 

Now I want to make a dataset, where I only want the rows from A, which match Bilag which is filtered out. 

I think it is at sort of vlookup. In the excel file I have shown what I want.

3 REPLIES 3
alexnajm
18 - Pollux
18 - Pollux

Use a Join tool then to bring these together:  Join Tool

alexnajm
18 - Pollux
18 - Pollux

There's a whole interactive lesson to learn more about the Find Replace tool as well: VLookUps with Designer - Alteryx Community. I would still use a join which is mentioned as well

binuacs
21 - Polaris

@Kjaer 

image.png

Labels
Top Solution Authors