Learning Path 1: Exercise 2: General

[yamini_k]

Assignment 2 solution

[ycai]

Spoiler

[ferncl2025]

I did it!

[nh97]

👍

[avijay11]

Practice Exercise 2

[Shwetapansari]

Solution 

[JavierTR]

Solution practice 2

[brian_skinnell]

Done.

[vaishnika]

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.

[Ayush_K_Menon]

Submitted