To perform;
"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 + \)."
I used the UNION tool to combine the initial states, used the UNIQUE tool on the result to filter out the duplicate customers.
On the user details, I used the TEXT-TO-COLUMNS tool to separate using delimiters.
Finally, the results of the above two were taken as input to the JOIN tool where they were matched on the customer-id from left and field2 from the right.
