Add Value in the Column with identifier

[k3pineapple]

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

[grazitti_sapna · Accepted 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!

[k3pineapple]

The 2nd method is one i'm looking for !!! Thank you very much, just realize the replace tool has append function.

[binuacs · Accepted solution]

@k3pineapple similar to  @grazitti_sapna approach

[grazitti_sapna]

@k3pineapple  thanks for accepting my solution and glad it worked for you 🙂