Merging Data

Question

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         c1c2c3  c1r1abc r1xr2abc   r3abc          Table 1[c1]is different toTable 2[c1]           Result should be            c1c2c3c4  r1abcx  r2abcx  r3abcx

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

MarqueeCrew · Accepted Answer

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 Answer

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).

MarqueeCrew · Accepted Answer

@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