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