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

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.

community.yxmd

Help

Join

Accepted answers

griffinwelsh

@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.

community.yxmd

All comments

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

@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.

community.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703