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

Help in find and replace tool.

shankar12
8 - Asteroid

Hi 

 

I am working on a requirement finding and replacing a field for that attached workflow i tried, the data getting truncated in output and for Null its not returning value.

 

In 1 find and replace tool can we use multiple.

 

Thanks.

7 REPLIES 7
JoshKushner
12 - Quasar

Your replacement is truncating because the field isn't large enough to contain the replacement. This is very common with text tool inputs. If you insert a select tool you can see the PO Indicator field size = 2. Increase the size to handle all replacements. (above 5 should be good, maybe above 1,000 to be safe for any text)

 

Field Size

select tool.PNG

ivoller
12 - Quasar

Hi,

 

Truncation is because field sizes are different. For Nulls (or empty fields) you can use a temporary value to use in Find Replace. See attached.

 

2018-08-21_8-49-23.png

shankar12
8 - Asteroid

tried using select and changed the size to 10000 still its truncating.

 

Thanks

 

shankar12
8 - Asteroid

your workflow results are showing the Ye for yes , i used auto field tool also still same Ye.

 

Thanks.

JoshKushner
12 - Quasar
Did you put the select tool right after your top text input?
JoshKushner
12 - Quasar

This should work

 

Workflow

workflow.PNG

 

Results

results.PNG

shankar12
8 - Asteroid

Thanks A lot Josh, it worked.

 

Regards

Shankar

Labels