I used union for Start2.1 and Start2.2 and then unique to remove duplicates. Furthermore, I used Parse text to column with delimiter " | " pipe and then using select to rename the columns and then using join to merge the customer transaction and users detail.