This workflow combines two customer transaction files (Start 2.1.yxdb and Start 2.2.yxdb) and merges them with a user information file (User Details.txt). The process begins by importing all three datasets. The two transaction files are united using the Union tool to create a single consolidated dataset. A Unique tool is then applied to remove duplicate users based on the UserID field. Next, a Join tool merges this cleaned transaction data with the user details, which are pipe-delimited (|). Finally, a Select tool refines the field order and names, and the Output Data tool exports the cleansed and combined data as Final State - Exercise 2.yxdb.
