Hi everybody,
I would ask in here for some ideas because i'm running out of ideas for what i have to accomplish, as it is displayed below:
I have 2 different tables in excel workbooks, im trying to do a VLookUp process to add some information from the table 2 to table 1, for this I´m currently using a Find and Repalce tool. The problem in here is that half of the 15k values are duplicated (sometimes i could find 3 or more times the same value), so do you have any idea of how could i make this find and replace or any other tool works for this?
So basically i need to match date and value and add the information of the color to the first table....
The tables abovementined are kind of like the followings:
TABLE 1 | TABLE 2 | ||||||
Concept | Date | Value | Concept | Date | Color | Value | |
A | 20/05/2020 | 100 | A | 20/05/2020 | Red | 100 | |
B | 20/05/2020 | 323 | B | 20/05/2020 | Geen | 323 | |
C | 20/05/2020 | 266 | C | 20/05/2020 | Blue | 266 | |
D | 20/05/2020 | 266 | D | 20/05/2020 | Black | 266 | |
A | 20/04/2020 | 266 | A | 20/04/2020 | Purple | 266 | |
B | 20/04/2020 | 400 | B | 20/04/2020 | White | 400 | |
C | 20/04/2020 | 50 | C | 20/04/2020 | Yellow | 50 | |
D | 20/04/2020 | 323 | D | 20/04/2020 | Brown | 266 | |
A | 20/04/2020 | Golden | 266 | ||||
B | 20/04/2020 | Silver | 323 | ||||
C | 20/03/2020 | Violet | 323 |
Do you have any idea for avoiding for example, that the third value in table 2 will be the only one that would be added in all the corresponding cases?
Thanks for your support.
Solved! Go to Solution.
Could you match on Date, Value and Concept? Then I would recommend a Join tool...if not I have another idea but first let's start with whether you can match by Concept as well.
Thanks,
J
I have tried, but sometimes concepts are the same, and the inconvenient in that, was that join was duplicated the number of records.... from 15k to 30k, it was more difficult to know which ones were the original records from table 1, that is the reason for which i´m trying to use Find and Replace tool for adding the field "color" to the original records.
This solution has work and help me to finish my tables, thanks for your help.