Not OK Data

Not OK Status.png

Hi All,

Appreciate the help if anybody can provide me the solution to filter out the Not OK data status such as leading spaces, trailing spaces, embedded tabs and so on in Alteryx. Instead of handling them using the Data Cleansing tool, I prefer to have those Not OK data status to be extracted or to be place in a new column for my reference. I attached an image to show one of the example for Not OK status data.

Thank You !

Preparation

Accepted answers

philipmannering

If you want to highlight the Not OK rows, you could use the following formula (type is Bool),

REGEX_CountMatches([Prep1], '^\s|\s$|[\n\t]')

This will flag TRUE if there is leading or trailing whitespace OR if there are embedded new lines or tabs... which you can then easily filter out.

See example attached,

Flag Not OK.yxmd

All comments

AncientPandaman

duplicate column
data cleansing the duplicate
filter the different between columns

philipmannering

If you want to highlight the Not OK rows, you could use the following formula (type is Bool),

REGEX_CountMatches([Prep1], '^\s|\s$|[\n\t]')

This will flag TRUE if there is leading or trailing whitespace OR if there are embedded new lines or tabs... which you can then easily filter out.

See example attached,

Flag Not OK.yxmd

philipmannering

Hi @AshrafHaris. Does my solution work for you? If so, please mark as a solution.

AshrafHaris

Hi Philip,

Thank you for the solution. But I have altered the solution a bit by not using the Regex Expression.

In a way it's the same concept which by tagging the Not OK data with TRUE or FALSE expression just like you showed me.

Thank You so much!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703