Merging Data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ok. Here is your hint:
Yes, you can append that field to all of your rows.
Table 1 is connected to the T anchor (Target). Table 2 is connected to the S anchor (Source).
Cheers,
Mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks to both of you - I was not aware of the append tool - both options work perfect and problem solved now :-)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.