Using Find and Replace to append the data, but it's not functioning

[PrasoonUprit]

I'm trying to use Find and Replace to append the data, but it's not functioning like I want it too. I also face the same issue in excel, I have to first delete the T1 Rows equaling the total amount of T1 related to ABC and then use lookup again with DEF.
is there any solution for this in Alteryx?

Thank you.

[OTrieger]

@PrasoonUprit 
Find and replace is working only with string type fields. If you are trying to Find and Replace values, then change their data type before the tool, you can always change the data type after it if needed.

[griffinwelsh · Accepted solution]

@PrasoonUprit I think this is the solution you are looking for. To my knowledge you will not be able to do this with just a find and replace tool.

[PrasoonUprit]

@griffinwelsh thanks a bunch!

[PrasoonUprit]

there's just a tiny problem I'm facing, the results seem to be inflated by 50,000,000 when increasing the Types from T1 to T2, T3 etc.