Vlookup False Values
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I want to do a v-lookup in sheet2 with another spreadsheet (sheet1) and want to get results as unique values (#N/A)
request you please check the spreadsheet I've attached.
require data - sheet2 highlighted column
Solved! Go to Solution.
- Labels:
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
you can use the Join tool for this with the L and R anchors set to point to the respective columns you want to match between the sheets. The output anchor L gives you the records (i.e. rows) that only exist in input L but not in input R. Likewise, the output anchor R gives you the records that only exist in input R but not in input L.
The following link Vlookups with Designer gives the full step-by-step detailed guidance on how to get started with this tool if you are new to Alteryx Designer.
Cheers,
Dawn.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
you can also look at the find and replace tool
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you so much
