User Details
Initial State
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
Practice Exercise 2
Combine both sets of Customer Transactions,
then combine those entries with the
User Details information.
Combine the Customer Transaction data in "Start 2.1" and "Start 2.2" and ensure there are no duplicate users. Then combine those results with the "User Details". The "User Details" information is delimited by pipes, |. (ctrl + \).
Final State
Final State - Exercise 2.yxdb
Final State - Exercise 2.yxdb
Start 2.1.yxdb
Start 2.1.yxdb
Start 2.2.yxdb
Start 2.2.yxdb
Warning
All
ByName
Customer_ID - Ascending
Field1
Last
split
Horizontal
Practice Exercise 2-Completed