Merging Data

[goergl]

Hi,

I am a new user of alteryx and here's my question:

I have a table and a unique entry:

	Table 1				Table 2
	c1	c2	c3			c1
r1	a	b	c		r1	x
r2	a	b	c
r3	a	b	c
Table 1[c1]	is different to	Table 2[c1]
	Result should be
	c1	c2	c3	c4
r1	a	b	c	x
r2	a	b	c	x
r3	a	b	c	x

Would this be something I can achieve and if so could anyone give me a hint?

[MarqueeCrew · Accepted solution]

Ok.  Here is your hint:

Yes, you can append that field to all of your rows.

Spoiler

Use the APPEND FIELDS tool.

Table 1 is connected to the T anchor (Target).  Table 2 is connected to the S anchor (Source).  

Cheers,

Mark

[jdunkerley79 · Accepted solution]

If you have a field to match between the two data sets then you can use the Join tool (https://help.alteryx.com/10.6/Join.htm).

If however you just want to append the data from the second table to the first then use the Append Fields tool (https://help.alteryx.com/10.6/AppendFields.htm).

[goergl]

Thanks to both of you - I was not aware of the append tool - both options work perfect and problem solved now :-)

[MarqueeCrew · Accepted solution]

@goergl,

Glad that we could help.  @jdunkerley79 & I are eager to share with the community.  BTW, you can mark both of our solutions as 'Accepted'.  We'll both earn credit for the answers and the community will recognize these as solved problems.

Cheers,

Mark