Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Help with removing specific data from a string

EswaraRajitha
5 - Atom

Hi

 

I have a string data in the below format

 

sairam9@gmail.com|Ram3@gmail.com|srilatha6@gmail.com|guru45@gmail.com

 

And i have a list of valid email address like below

1.sairam9@gmail.com

2.guru45@gmail.com

 

So i would like to check each email address whether it is there in the valid list and keep only that data

 

Output data should be as below

sairam9@gmail.com|guru45@gmail.com

 

I tried find and replace but it is taking longer time for processing the data

 

Can anyone of you suggest me the best practice so that i could achieve it

 

4 REPLIES 4
Assaf_m
11 - Bolide

Check attached solution

 

Assaf_m_0-1623141927868.png

 

mceleavey
17 - Castor
17 - Castor

Hi @EswaraRajitha ,

 

This is the perfect use case for the Find and Replace tool:

 

mceleavey_0-1623142410374.png

 

This searches the text string for the emails and returns the matched email in an additional column.

 

mceleavey_1-1623142466920.png

 

mceleavey_2-1623142492538.png

 

Workflow attached.

 

I hope this helps.

 

M

 



Bulien

Qiu
19 - Altair
19 - Altair

@EswaraRajitha 

Similar with others reply.

0608-EswaraRajitha.PNG

mceleavey
17 - Castor
17 - Castor

Hi @EswaraRajitha ,

 

In addition, there's a simple concatenation method which pivots the data out into rows, then concatenates into a cell separated by pipe:

 

mceleavey_0-1623144131366.png

 

mceleavey_1-1623144162308.png

 

M.

 

 



Bulien

Labels