Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Find & Replace Tool - Replace Drop-Down does not Display Value Option

kheuer
8 - Asteroid

Hello,

 

This is my first time experimenting with the Find & Replace tool. I have a simple lookup list setup in an XLSX document that I am pulling in via a Text Input tool into the R Input connector of the Find and Replace tool. Based on everything I am reading, I should be seeing a list of the two columns (named "Find" and "Replace") that I have setup in my lookup list. It is not showing up in the list. I tried removing all tools and starting over. I created a new workflow. I pulled in Input Tools instead of Text Inputs. So far nothing has worked. If you look at the screenshot you can see that Alteryx understands that I have a second column since it lists "Replace" as an option for appending which is not what I want.

 

Please help.

 

Thanks,

Kristina

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

Find Replace only works with string data types....

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
kheuer
8 - Asteroid

That would explain it. :) 

Thank you!

Labels
Top Solution Authors