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.

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
20 - Arcturus
20 - Arcturus

@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