Dev Space

Customize & extend the power of Alteryx. SDKs, APIs, custom tools, and more!

Apply Xlookup the same table

AS
8 - Asteroid

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- 

CodeABCResult
1400400400
1400NA400
1431431431
1485485485
1117117117

 

1 REPLY 1
RishiK
Alteryx
Alteryx

@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.