Challenge #443: Mystery of the Unjoined Records

[RWvanLeeuwen]

here we go with challenge 443

Spoiler

I intended to add an Expect Zero records (Count=0 then ok, otherwise, error) - but Alteryx Designer broke down after buildling out this additional piece of logic

[ggruccio]

Used a regular expression to remove the strange "ghost" characters.

Spoiler

[murune11432]

solved!

[AmitDass]

 Challenge #443: Mystery of the Unjoined Records_Solved

[JeffHeidel]

REGEX

[agomoll]

Good practice for identifying data cleansing needs

[dlash]

Select to update the vartype and cleanse tools

[kawikaf]

[savannahjane7]

Good exercise!

[Paulogm1]

Here is my solution:

Spoiler