Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Dev Space

Customize and extend the power of Alteryx with 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.