Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Find Replace to append fields with Integer as keys

mstoler
8 - Asteroid

Hello,

 

I like to use the Find/Replace to append fields but I have a situation where I have Integers.

 

Is the only solution to convert the Integers to Strings for the Find Replace to work?

 

Thanks,

 

Michale

 

3 REPLIES 3
fmvizcaino
17 - Castor
17 - Castor
Hi,

Unfortunately yes for find replace tool, but you can use the join + union
tool and that would give the same result as well.

Best,
Fernando Vizcaino
JosephSerpis
17 - Castor
17 - Castor

Hi @mstoler you are correct Find and Replace will only work with string fields. The Join tool might be approach if your data is not a string. Do you have some example data and an expected output you can share?

mstoler
8 - Asteroid

Hello,

 

I am going to use a formula tool and convert to a string using tostring.

 

Not a big deal.  I like the way Find Replace can append fields.

 

Thanks,

 

Michael

 

Labels