Im attempting to add a coloumn- similar to the vlookup foundation - Based on the OrderID - and then get one table with the Employee ID against the OrderID
Input File 1 | ||||
OrderID | Name | Cost | Style | Fabric |
747380 | Kevin | 1500 | Tops | Cotton |
747896 | Mark | 1500 | Tops | Denim |
787985 | Mary | 1000 | Tops | Organza |
759876 | Rose | 1000 | Bottoms | Cotton |
758964 | John | 2000 | Bottoms | Silk |
Input File 2 | |
OrderID | Employee ID |
758964 | 874563 |
787944 | 625741 |
747380 | 125478 |
759876 | 963753 |
747896 | 159357 |
758963 | 963755 |
787985 | 963258 |
747311 | 111585 |
759800 | 111586 |
747159 | 158742 |
Output required
Output | |||||
OrderID | Name | Cost | Style | Fabric | Employee ID |
747380 | Kevin | 1500 | Tops | Cotton | 125478 |
747896 | Mark | 1500 | Tops | Denim | 159357 |
787985 | Mary | 1000 | Tops | Organza | 963258 |
759876 | Rose | 1000 | Bottoms | Cotton | 963753 |
758964 | John | 2000 | Bottoms | Silk | 874563 |
Solved! Go to Solution.
Thanks Luke - I have used this to review where my output is breaking