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!

Alteryx Designer Desktop Discussions

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

Lookup the will return multiple values

cablejarrett
6 - Meteoroid

Good Morning, 

 

I have a issue where I need to look up one value and return all that match - in the example below I have 1 spreadsheets with customer data (blue) one with Price data (green) and need to return the example in (yellow). 

 

 

cablejarrett_0-1649428248743.png

 

4 REPLIES 4
binuacs
21 - Polaris

@cablejarrett Have you tried using the join tool by joining the price list name in both the table?

cablejarrett
6 - Meteoroid

yes. but it just joins those lines. I need to to return allll the matching product values.

binuacs
21 - Polaris

@cablejarrett This can be done with the help of the join tool and the multi row tools. 

binuacs_0-1649430345973.png

 

urbot
7 - Meteor

how to have match values in one single cell instead of multiple row ex: if Red matches returns with baseball, baseball in column and then 456,76452 in another cell columns

Labels
Top Solution Authors