Vlookup
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Kjaer
8 - Asteroid
01-31-2025
05:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Custom Tools
3 REPLIES 3
18 - Pollux
01-31-2025
05:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Use a Join tool then to bring these together: Join Tool
18 - Pollux
01-31-2025
05:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
02-01-2025
02:40 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
