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

Urgent Data cleansing

Anniefang
7 - Meteor
Hi there, I had an issue trying to cleanse a data for comparison. The data have multiple columns that contain concatenates, e.g. some rows in column C show “ Argentina|2010|March|Economy” and some rows in column D show “Spain|2023|June|growth”.. I did multiple text to column bit then it created a lot of blank fields, and sometimes the columns don’t match their respect headers (e.g need to delete some of the blank cells). Just wondering if there’s any quicker way of doing this cleansing in Alteryx?
11 REPLIES 11
estherb47
15 - Aurora
15 - Aurora

Sure! You can adjust the filter so that the Regex_CountMatches function looks for more than zero matches (REGEX_CountMatches([Value], "\|")>0)

The shorter fields won't be parsed by the RegEx parse tool. So add a formula tool afterwards and fix the first column from the RegEx parse tool with the following function:

 

image.png

Cheers!!

NJT
11 - Bolide

Thanks for sharing the problem and the additional data and letting us know a solution worked for you, this will definitely come in handy for future community members when looking for a solution to similar problems. 

Labels