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?
Solved! Go to Solution.
Ok. Here is your hint:
Yes, you can append that field to all of your rows.
Cheers,
Mark
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).
Thanks to both of you - I was not aware of the append tool - both options work perfect and problem solved now :-)
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