Adding a column of data to a dataset

Question

I was wondering if it is possible in Alteryx to append a column of data into another dataset with limited relationship between the data. I am attaching a spreadsheet with 3 tabs, A, B, and C. What I am trying to do is A + B = C. Can somebody please help me here? An example in Alteryx will be very helpful.

Here is a simplified example

Dataset A    Dataset B  Dataset C - result   Col ACol BCol CCol D Col ACol B Col ACol BCol CCol DCol EADGH A1 ADGH1A GH A2 A GH2BEIJ A3 A   3CFKL A4 A   4COMN A5 A   5CP   A6 A   6     A7 A   7     B8 BEIJ8     C9 CFKL9     C10 COMN10        CP

I appreciate any advice and feedback on this. Thank you!

Bob

data.xlsx

gabrielvilella · Accepted Answer

Hey @ryoung042, here is one way of doing this.

amruthas2 · Accepted Answer

Hi @ryoung042

Please let me know if this solution works for you