Combine both the table using union tool. Select unique tool to extract un iqe value by checking Customer_ID. Select Text To column tool with user detail. select pipe as delimitersand choose 5 as number of column. choose select tool to rename column. Choose join tool. select join by specific column, choose customer_ID at left and right. Then run.
Exercise 2
Good exercise
Good afternoon