Junk values coming in to Website field

[Nageswar_GEM]

My CRM sends non Website data like "Website not found" , "Website under construction" etc and there is a validation to receive only data like WWW.abd.com, www.abd.com, starts http and ends with .com , .com,in, .in. Because of this data issue the integration stops and requests flow comes to a halt.

How do i use RegEx tool or any other to exclude all of the valid formats and through out the text values using an excel and send in an email. I want to do this from my SQL table into which my CRM pushes the data.

[atcodedog05]

Hi @Nageswar_GEM 

Can you provide some sample data and expected output. So that we can help out. Current workflow has a db connection hence we wont be able to get a sample data.

[Nageswar_GEM]

as i mentioned the values i get are "No Website found", "Website not working", Website Under Construction". So if these kind of non website format values are coming then should be highlighted and pasted in an excel output.

now i have the WF attached. The input file has the last column, Website. Please advise how to generate an output only for the non website data like NULL, Website Not found, Website Under Const.

[atcodedog05 · Accepted solution]

Hi @Nageswar_GEM 

If you want capture rows with values "No Website found", "Website not working", Website Under Construction". You can use a filter like below. You can add more status code in the list (within the bracket) to check.

Hope this helps🙂

[atcodedog05]

Hi @Nageswar_GEM 

To send the excel with expectations through email here is what you can do.

1. Output the excel file to a location.

2. If the filename and location is same you can configure the email tool with the attachment file path.

3. If your filename and path changes you can pass the filepath+filename as through a field.

This blog & video might help

Blog : https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Email/ta-p/32129 

Video : https://www.youtube.com/watch?v=_OgEvg8w4vo 

Hope this helps 🙂