Trying to merge the Customer ID to the Customer Transaction Data

[mxledesma]

Hello, 

From the Practice 2 from the learning path

I am trying to Merge the Customer Transaction Data to the Customer ID from the user Details but I am not sure if I need to use the Fuzzy Match tool, If so i am not sure how to configure it.  I know that i used the Text to column correctly to split the delimiters. 

The first file is my design so far and the second file is the correct output that I am suppose to get.

I am confused on my workflow. 

If anyone can help it would be greatly appreciated.

[fmvizcaino]

Hi @mxledesma ,

Would you be able to share the exercise datasets, please?

Best,

Fernando V.

[mxledesma]

Thanks for responding. Here are the exercise data sets. 

[grazitti_sapna]

Hi @mxledesma , I do not think there is requirement of fuzzy match in order to make sure there is no duplicate user you can simply use a unique tool. Please refer to the screenshot and the workflow attached along.

Cheers!

[sravanireddy_24]

Combine both sets of Customer Transactions,
then combine those entries with the
User Details information.