Initial State
Practice Exercise 2
Combine both sets of Employee Transactions,
then combine those entries with the
Employee Details information.
Combine the Employee Transaction data in "Start 2.1" and "Start 2.2" and ensure there are no duplicate employees. Then combine those results with the "Employee Details". The "Employee Details" information is delimited by pipes, |. (ctrl + \).
Final State
Start 2.1.yxdb
Start 2.1.yxdb
Start 2.2.yxdb
Start 2.2.yxdb
Employee Details
Bob|1128|5847 Union St|Arvada|80004
Lou|2911|2751 Wolff St|Denver|80212
Jack|787|915 S Lima St|Aurora|80012
Drew|483|12801 E Kansas Pl|Aurora|80012
Nancy|466|2721 S Truckee St|Aurora|80013
Patrice|2|376 S Jasmine St|Denver|80224
Zara|252|1177 Sequerra St|Broomfield|80020
Sherry|3310|15935 E Bethany Pl|Aurora|80013
Ralph|960|4851 S Genoa St|Centennial|80015
Hudson|1319|5595 S Kenton Way|Englewood|80111
Final State - Exercise 2.yxdb
Final State - Exercise 2.yxdb
Warning
All
ByName
Field1
Last
Horizontal
Practice Exercise 2