We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
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
Start Free Trial

Alteryx Designer Desktop Discussions

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

Pull data from certain columns based upon a specifics within another column

EmilAlteryx01
8 - Asteroid
‎05-14-2024 07:55 AM

What is the best way to pull data from certain columns based upon a specifics within another column - attached is my output sample.
2) I am trying to recreate a "Table" in alteryx, essentially doing a lookup on columns F6-K6 using data from the "E" column.
2) My Excel has =IF(ISNUMBER(FIND($E$10,$G$6)),"-","NOT APPLICABLE") as well

Preview file
14 KB
Reply
0 Likes
0 REPLIES 0
Community Live
Labels
Top Solution Authors
View All