In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
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

CS Owner for Related .xlsx
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
view community events
Labels
Top Solution Authors
View All