Hi all
I need to add values into the column to replace the data in this column for specific rows. Not sure whether i should use "Append" there.
Here is the sample output, target & source table has been attached there. Thanks for your time.
Firm | Product | User | User Type | Reason |
A | AA | Amy | Tier 1 | Replacement |
A | BB | Bob | Tier 1 | Retirement |
D | AA | Charlie | Tier 2 | NA |
G | AA | Dog | Tier 3 | |
G | BB | Eason | Tier 2 | Just wanna change |
G | CC | Frank | Tier 1 |
Solved! Go to Solution.
Hello @k3pineapple, this can be achieved using the join tool.
Another method is by using the find and replace tool.
I hope this helps!
Thanks!
The 2nd method is one i'm looking for !!! Thank you very much, just realize the replace tool has append function.
@k3pineapple thanks for accepting my solution and glad it worked for you 🙂