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

Alteryx Designer Desktop Discussions

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

Find and Replace Workflow XML

kpsrawat
8 - Asteroid

Hi, 

 

Looking for simple Alteryx O/P workflow XML file (.yxmd format) with "FindReplace" job .

 

Find text  "ABC" replace with "XYZ"

 

Actions as  "Input Data (csv) --> FindReplace --> Output Data" workflow.

 

 

Thanks,

Kunwar

11 REPLIES 11
atcodedog05
22 - Nova
22 - Nova

Hi @kpsrawat 

 

Here is replace function which you can leverage through formula tool.

 

If you have more scenarios find and replace scenarios use find and replace tool

 

PhilipMannering
16 - Nebula
16 - Nebula

Here you go. See attached an xml file (yxmd) as you described...

atcodedog05
22 - Nova
22 - Nova

Hi @kpsrawat 

 

Here is a workflow for the task.

Workflow:

atcodedog05_0-1605681748920.png

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

kpsrawat
8 - Asteroid

Hi @atcodedog05  / @PhilipMannering 

 

Need some clarity with respect to usage of FindReplace component 

 

In the workflow xml I can see TextInput component, Plugin="AlteryxBasePluginsGui.TextInput.TextInput"

 

Can you please confirm if this component is mandatory to use with FindReplace component ? 

 

Thanks,

Kunwar

atcodedog05
22 - Nova
22 - Nova

Hi @kpsrawat 

 

Sorry i dont have much clarity on xml config of the workflow😅

kpsrawat
8 - Asteroid

Hi @atcodedog05 

 

Not an issue 😶

 

Can you share with me a simple job flow output xml file like below 

 

Input Flat File -----> Find Replace -----> Output Flat File

PhilipMannering
16 - Nebula
16 - Nebula

Hi @kpsrawat 

 

Can you mark as correct if we have provided what you need?

Then we will be more likely to help with future requests.

 

Thanks,

Philip

kpsrawat
8 - Asteroid

Hi @PhilipMannering 

 

The solution provided is correct as per the request. 

Need clarity as in one solution formula component is used where as in other Text Input component is used. So, I am looking for a simple basic workflow without using any addon's 

 

Input File ---> Find Replace ---> Output File 

 

So, that its easy for me to understand the XML behind FindReplace tool and start the implementation and later addup the addon features 

 

Thanks,

Kunwar 

atcodedog05
22 - Nova
22 - Nova

Hi @kpsrawat 

 

apologies for the delay

 

Here is a workflow for the task.

Workflow:

atcodedog05_0-1605771276167.png

 

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Labels