Alteryx Designer Desktop Discussions

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

VLookup - Retrieve more than one field

msantoso
8 - Asteroid

hello everyone, 

 

I've searched for an example before posting a new request, but could not find any. 

Sorry if in case, my question has already been answered :)

 

I have a file containing company numbers and a grouping code.

My second file contains this grouping code and many other fields. 

I'd like to join the two files and copy into the first file two specific fields.

 

Could anyone explain how to do that ?

many thanks

 ms

11 REPLIES 11
agentzerow
7 - Meteor

i pulled together a few ways of achieving your output with the join tool.

msantoso
8 - Asteroid

THANK YOU !! 

 

hi AgentZerow, you made my day!!

 

Have a nice day

myriam

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels