VLookup - Retrieve more than one field

[msantoso]

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

[BenMoss]

The Join tool shpu l d provide you with the functionality you are looking for.

One of your datasets will go into the left anchor input and the second in the right anchor input.

Specify your join field (the group code field in your instance).

At the bottom of the join tool you can specify which fields you would like in your outgoing data stream

Ben

[msantoso]

Thanks a lot Ben! I got it!

May I ask you another question? 

the solution you provide works if the field I want to retrieve is NOT in the target file. 

How to do if the field does exist, and I want to populate it with the JOIN? 

thanks 

Myriam

[agentzerow]

Not exactly sure what you mean, I am thinking you looked at the left output.

Left output - you can see data from your left input which did not match anything

Join output - you can see data that is common between the two inputs

Right output - you can see data from your right input which did not match anything

You can use a union tool alone or with formula tools to join all of the data back together if you need it.

[msantoso]

Hi AgentZerow,

thanks for your help. 

Sorry, I was not clear enough :(

In my entry file, I have one field containing a code value

In my mapping file, I have 3 fields : , the code value, a second field which is mapping with the code value, and a third field which is depending on the second. 

Example 

entry file field = 106

mapping file field1 = Industry

mapping file field2 = Industry Oil, Gas, Energy

entry file field = 107

mapping field1 : Industry

mapping field2 = Industry chemi, Pharma

These 2 output file fields already exist in the output file. I'd like to know if I can retreive the values without to append the 2 fields

I wish to have in my output file: 

107 ; Industry ; Industry chemi, Pharma

i could just APPEND the 2 fields with the JOIN tool.

but these 2 fields already exist in the output file with other values. 

hope you have the answer :)

thanks

myriam

[agentzerow]

Might it be possible to attach sample Excel files showing the format of your inputs and the final output you want to see? Or, you could even paste it in the reply instead of attaching the Excel.

[msantoso]

Hi AgentZerow,

here is a sample file:

tab1 represents my source file

tab2 is the mapping table 

and tab3 is what I'd like to get to 

As you can see, I already have some values in the source file. 

thanks for your help

Myriam

[msantoso]

Hi AgentZerow,

here is a sample file:

tab1 represents my source file

tab2 is the mapping table 

and tab3 is what I'd like to get to 

As you can see, I already have some values in the source file. 

thanks for your help

Myriam

[msantoso]

Hi AgentZerow,

here is a sample file:

tab1 represents my source file

tab2 is the mapping table 

and tab3 is what I'd like to get to 

As you can see, I already have some values in the source file. 

thanks for your help

Myriam

[msantoso]

Hi AgentZerow,

here is a sample file:

tab1 represents my source file

tab2 is the mapping table 

and tab3 is what I'd like to get to 

As you can see, I already have some values in the source file. 

thanks for your help

Myriam