This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've done some pre-work cleaning data as it comes in via query, though there are outliers that I don't want to continue to accommodate via SQL. I'd rather do any additional cleansing/normalization of the data using the Alteryx tools, if possible.
When certain text shows up in a field, I need it removed....THEN normalize what is left over into a consistent format, with leading zeros.
I believe data can be removed via: REPLACECHAR(REPLACECHAR([Yourfield],'"',''),"'","")
Pending that works, how would I have the tool (or another in a following step) analyze and append needed leading zeros.
Fantastic! Thanks everyone! Looks like everyone had more or less the same idea.
I was about to punch myself as I wasn't getting the desired result until, like an idiot, I realized I wasn't replacing my key column as the output of the flow. Did that and getting the hits I was looking for. This was perfect. (PS...I went with the Data Cleansing tool as it was much simpler for what I needed. I'll keep the regex in mind if I end up with more complex stuff, that's what I used in the originating query)
PS. Don't mind the million browses and multiple outputs 🙂 Doing some checks along the way.