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
Solved! Go to Solution.
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
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.
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
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.