Adding a column of data to a dataset

[ryoung042]

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 A

Col B

Col C

Col D

Col A

Col B

Col A

Col B

Col C

Col D

Col E

A

D

G

H

A

1

A

D

G

H

1

A

G

H

A

2

A

G

H

2

B

E

I

J

A

3

A

3

C

F

K

L

A

4

A

4

C

O

M

N

A

5

A

5

C

P

A

6

A

6

A

7

A

7

B

8

B

E

I

J

8

C

9

C

F

K

L

9

C

10

C

O

M

N

10

C

P

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

Bob

[gabrielvilella · Accepted solution]

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

[amruthas2 · Accepted solution]

Hi @ryoung042 

Please let me know if this solution works for you

[ryoung042]

Wow, you guys are amazing! The community is awesome and I've learned so much from various topics to solve my many problems :) Thank you @gabrielvilella and @amruthas2 for your quick response time. I found the "tile" function especially effective. Who would've thought the solution was so simple!