Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data type error

Kinetic_analytics
11 - Bolide
‎12-23-2021 09:18 AM

Hello:

How can I solve it:

=IFERROR((IF(F2=0,0,VLOOKUP(F2,E:N,10,FALSE))),0)

 

Thanks

Preview file
10 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
Kenda
16 - Nebula
16 - Nebula
‎12-23-2021 10:07 AM

Hi @Kinetic_analytics 

 

Use a Join tool and connect your data to both the L and R inputs. Select Case ID for one dropdown and Related Case as the other dropdown to join by. This should get you pretty much there.

Reply
0 Likes
apply to be an alteryx mentor
Join the tampa, florida User Group
Labels