Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
Top Solution Authors