Apply Xlookup the same table
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Printer Friendly Page
AS
8 - Asteroid
‎07-20-2021
03:41 AM
- Mark as New
- Subscribe to RSS Feed
- Permalink
Hi,
I'm stuck on a point when Excel has a function XLOOKUP and I could not able to apply the logic. Could you guys help me-
This is the lookup formula i need to apply on result column =XLOOKUP([@[Code]],[ABC],[ ABC],"NA",0)
Expected result would be-
Code | ABC | Result |
1400 | 400 | 400 |
1400 | NA | 400 |
1431 | 431 | 431 |
1485 | 485 | 485 |
1117 | 117 | 117 |
Labels:
- Labels:
- Custom Tools
- Developer
1 REPLY 1
Alteryx
‎07-21-2021
03:29 AM
- Mark as New
- Subscribe to RSS Feed
- Permalink
@AS I have just replied to your other post on this. Have a look at the link below,
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Replicate-Excel-XLOOKUP-Func...
This is a good step by step guide to support you to get to your expected output or know more on how to replicate the XLOOKUP in Alteryx.
